SQL Server Performance Forum – Threads Archive
copy DTS between SQL serversHi there, I am trying to copy DTS packages from one SQL server to another. Has anybody done? Is it possible at all? Thanks & Regards,
If you don’t have a lot of packages to copy, you can save them as Structured Storage Files, then copy them to the new server. Once there, open them, and save them in SQL. See "Location" in the Save As dialog. If you do have a lot to copy, take a look at DTS Backup 2000 at SQLDTS.com . http://www.sqldts.com/default.aspx?272 I haven’t used it, but have seen others recommend it. Steve
I’ve used it and works perfect, better than restoring the MSDB database <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ />.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided â€œAS ISâ€ with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
quote:If you don’t have a lot of packages to copy, you can save them as Structured Storage Files, then copy them to the new server.Or just open package and save it on a new server.
You can save dts as structure storage file and can open in another server.
try to insert data from one to another using sysdtspackages system table. D!shan
If you have the right permissions I second to what mmarovic suggested, some guy from my company asked me the same question yesterday and I replied with the same anwser "Open the package and save as to the other server" He was amazed that it was that easy. [<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />] Of cource he only had to copy over 5 packages and it would not be a viable solution for 100 + DTS packages. [xx(]<br /><br /><br />Raulie<br />Hewlett-Packard Company