Copying DTS "packages" from one SQL Server to another. 1

[VictorAnderson]

We are in the process of switching hosting companies and servers, and in about 16 hours the old one (which is now the 'current' one) is going to be turned off, so I'm in a bit of a bind to fix this rather quickly.....<br><br>The old one ('current') appears to have 58 of these 'DTS' &quot;Packages&quot;.&nbsp;&nbsp;Now, how the heck to I copy them to the 'new' server?<br><br>I'm hoping this is a basic question, it sounds like it should be simple.....<br><br>Thanks in advance for any help!!!!<br> <p>Victor Anderson<br><a href=mailto:victoranderson2000@imailbox.com>victoranderson2000@imailbox.com</a><br><a href=

http://www.vfpguru.com>VFP

Guru</a><br>ICQ# - 14847018

 

[foxdev]

Well, its a bit late, but I had to do this myself and did some research.

Two choices are clear (there may be others as well):

[tab]Save the DTS packages as files, copy them to the other server, then open and save them.

[tab]Transfer them via DTS (what else?) from one MSDB to the other. For detailed instructions on how to do this, check out this article:

http://www.swynk.com/friends/green/dtstransfer.asp

I think there might be a third option, but I have yet to try it: edit the package on the first server, then in the Save As simply change the server name. Seems too easy, but it might work (a bit tedious though if you have lots of packages).

Robert Bradley

http://www.foxdev.com/