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