Post reply

Editing DTS source soce

  • March 5, 2007 at 8:43 am

    #116618

    I am migrating hundreds of dts' from one server to another. Is there a way to edit the source code in a text file. I need to change the destination server name in all of my copy database objects task. Is there an easy way to do this?

    Thanks in advance,

    Wesman

  • March 8, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • March 8, 2007 at 10:22 am

    #693879

    There's a script in the script secton of this site that copies all packages stored in msdb to text files.  I've used it for packages that don't have passwords and it worked fine.  Search for "script all dts packages".

    Greg

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

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