Migrate multiple DTS packages from one server to another ?

• yu_wai

  Mr or Mrs. 500

  Points: 507

  More actions

  February 8, 2009 at 11:02 pm

  #73454

  I have hundreds of DTS packages need to be migrated from one server to another due to server upgrade. The server names are different, but the requirements need to migrate all packages across, then start running them on the new server.

  I have found the way to migrate all packages across, but the servername in both the connection strings and the logging properties tab remains the old servername.

  I also found some scripts using sp_OA.... method to do the migration and changing the servername of the connections strings, but this method will lose the text annotations & comments.

  I also found some scripts using ActiveX Script task to change the logging properties to use the new servername, but again, it loses the text annotations & comments.

  I wonder if anyone have had the similar problem before, that some solution been designed to do both things ? (changing all connection strings to use the new servername, changing the logging properties tab to log onto the new server, and retain all text annotations & comments.)

  Please give me some help....

  Many thanks.