Moving DTS package

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  March 11, 2009 at 1:52 pm

  #72694

  Hello,

  I have a dts package in sql server 2000 default instance. Now I need to move this DTS package to another default instance of new sql server 2000. How can I do this?

• Mike - CI

  SSCarpal Tunnel

  Points: 4146

  More actions

  March 11, 2009 at 2:12 pm

  #957868

  Open the package and do a Save As, where you specifiy a different server.

  Or this site has a nice tool for moving packages around.

  http://www.sqldts.com/

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737402

  More actions

  March 11, 2009 at 2:21 pm

  #957876

  Moved to DTS forum. Please watch where you post.

  Also, when you do the packages, if you can't see the new server, you can save as a structured storage file, copy that over, and load it in.