So you've been backing up your server, and it fails. You restore all of your databases, but onto a fresh install. You don't restore the system tables because you aren't using the same OS or Hardware or something, and aren't sure that's a good idea. But where are your DTS scripts? You need them, and don't have any other copies since they're a friggin' pain to develop in a development environ.
This article will try and explain the different ways you can transfer (DTS) packages between servers and other storage locations, either directly or as files. The most common requirement is to transfer between two SQL Servers, and this is the main focus here, but some methods can be adapted for any of the other storage locations.... You can also use a simple DataPump task to transfer the contents of sysdtspackages directly between servers...
This article will try and explain the different ways you can transfer (DTS) packages between servers and other storage locations, either directly or as files. The most common requirement is to transfer between two SQL Servers, and this is the main focus here, but some methods can be adapted for any of the other storage locations....
You can also use a simple DataPump task to transfer the contents of sysdtspackages directly between servers...
[ Transferring DTS Packages ]
Come on, could it be that easy? Seems to be so far...
Thank you Internet, bawk bawk!
dasBlog theme modified from "mads simple" theme by Mads Kristensen
Disclaimer The opinions expressed herein are my own personal opinions.