DTS Script

  • Hi all,

    Is there anyway of geeting DTS package to a Scripts or esle how can we make dts portable.




    My Blog: http://dineshasanka.spaces.live.com/

  • hi dinesh..

    jus use save as option and save it in structured storage file format ..that can be portable

    thnks

  • hi dinesh..

    jus use save as option and save it in structured storage file format ..that can be portable

    thnks

  • Thankx. Simpe thing Great Help




    My Blog: http://dineshasanka.spaces.live.com/

  • when you save it as a "structured storage" file format >>> when you open it on the destination server you will need to do a "save as" and save it to SQL server, so that you can see it in the GUI of DTS. You will have to modify connections and file paths to match the destination.

     

    Good luck.


    Don't count what you do, do what counts.

    SQL Draggon

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply