December 13, 2005 at 2:25 pm
Is there a way to import a DTS package from one SQL Server to another SQL Server?
December 13, 2005 at 2:55 pm
If it's just 1 package, open it up on 1 server and "Save As ..." on the other server.
If it's multiple packages, get the DTSBackup2000 tool:
December 14, 2005 at 6:27 am
Or you can save the package as a .dts file and then open this on the new server.
Regards..Graeme
December 15, 2005 at 9:18 am
Don't bother messing around with vb files or dmo. Use this:
See this article that helped me do such a thing. I now have an asp page that calls the dts copy package by selecting packages from one server into a list box. I then highlight the ones I want and copy across to another server.
http://databasejournal.com/features/mssql/article.php/1461521
December 15, 2005 at 2:46 pm
If you're not worried about losing your history, simply bcp out the contents of the msdb..sysdtspackages table to a file and import or use a dts transformation to move the contents from one server to another.
What I mean by history, is that you'll only get the latest version of your dts package. I've personally never had a need for old versions when moving, but you might.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy