Copy DTS Packages between Servers

• YCH

  SSC Eights!

  Points: 892

  More actions

  December 19, 2002 at 1:36 pm

  #105359

  I have multiple DTS packages on one server which I need to transfer to another server box. Is there any quick way to do this? I simply don't want to re-create all those packages on the new server.

  Thank you!

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  December 19, 2002 at 2:29 pm

  #444866

  Save package as structured storage file and move those .DTS files to the server and open from there.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  December 19, 2002 at 2:54 pm

  #444868

  This shopuld help

  http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

• philcart

  SSC-Forever

  Points: 47796

  More actions

  December 19, 2002 at 3:44 pm

  #444874

  We use the DTS Backup 2000 tool from the SQLDTS site. Works a treat and if permissions are set right you can perform direct transfers which preserves the layout.

  http://www.sqldts.com/default.aspx?220,272,272,1,1

  Thanks

  Phill Carter

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