How do you copy a DTS Package from one server to another

• Therese Hutcheson

  SSC Eights!

  Points: 823

  More actions

  July 26, 2007 at 11:44 am

  #69657

  A little more searching and I have figured this out - and it is amazingly simple!

  No assitance needed

  We have several databases and 20-30 DTS packages used for loading data to them on one of our servers (SQL Server 2000).  I need to move the databases and packages to another server.  Moving the databases is easy, but how do you move the DTS package?  Do I need to recreate the package on the new server?

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 26, 2007 at 11:23 pm

  #722768

  You can copy the content of sysdtspackages table to the destination server. But you will have to redo the connection settings in the new server.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  July 27, 2007 at 10:23 am

  #722960

  You can also open each and then "Save AS" to the new server or SAve As a Structured Storage file in the file system and move them.

  Sugesh' technique is the easiest.