Post reply

Moving DTS Packages

  • September 15, 2005 at 5:15 pm

    #165956

    Is it possible to scrip out the dts package and run it against different server? I have many dts packages need to be moved to a different server.  What is the best way to do it instead of re-creating those packages?

    Thanks so much

    Minh Vu

  • September 15, 2005 at 5:32 pm

    #590395

    Personally I prefer DTSBackup2000 http://www.sqldts.com/default.aspx?242

    But, like everything with SQL there are many ways. Try this for transferring directly from the table http://www.sqldts.com/default.aspx?204

    Always be aware that if the package has hard-coded references to Server and Databases names, then you'll need to edit the package on the new server to reference the new server.

     

    --------------------
    Colt 45 - the original point and click interface

  • September 15, 2005 at 6:30 pm

    #590407

    Be very careful if you have hard-coded references to Server. Transferring them will not change the server name. Things can be ugly if you execute them

    Kindest Regards,

    Amit Lohia

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

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