SQL Server Performance Forum – Threads Archive
Copy or Move DTS Packages
I had a question on how to move or copy a DTS package from one db to another one.Thanks
If you wanna copy DTS from one server to another in the same network then
open DTS in designer open save as dialogue box and enter the server details and click save to save it on another server. If another server is in diffrent network then read about structured storage file in BOL.
Save DTS in file format and send it to another server then open that file on serverB and then save it.
The best option is to backup MSDB and restore it on target server, thsi way you’re easily managing all scheduled jobs. Refer tohttp://www.sqldts.com/default.aspx?204 for relevant information. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi Satya
But would this not overwrite the existing MSDB and hence overwrite the existing jobs and packages.
Thanks i will take a look at the link u have posted.
Other option is to work with sysdtspackages, is msdb table.
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS†with no warranties for accuracy.
I will not incline towards loading a system table using DTS, otherwise refer to the link above. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Use a VB script to save the DTS packages to a file (as ranjitjain mentioned) and load it (using another VBScript) into your destination server. May the Almighty God bless us all!
www.empoweredinformation.com
]]>