SQL Server Performance Forum – Threads Archive
Saving DTS package
I have more than 100 DTS packages in one of my server. I want to copy all the DTA packages from one server to other.Is there any way to save all the DTS packages as a text file in one time. Saving individual package is very painful. Please advise.
quote:Originally posted by suneelmehra
I have more than 100 DTS packages in one of my server. I want to copy all the DTA packages from one server to other.
Is there any way to save all the DTS packages as a text file in one time. Saving individual package is very painful. Please advise.
Is there any way to save all the DTS packages as a text file in one time. Saving individual package is very painful. Please advise.
Please search on the site. It has been discussed many times. You just need to transfer your msdb..dtspackages table from source to destination server. Knowledge is not Power !!!
But When its acted upon then its Power !!!
No, I can’t over write the msdb database.
That is the only way to achieve the task in easy way to restore msdb database, if not you have to save them as a file and use on destination server. As referred search on forum for any clues. 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.
]]>