SQL Server Performance Forum – Threads Archive
How to restore DTS PacakgesDear Friends, I have to restore my DTS Packages. The issue is, I have Full Database backup and Full system backup. When my server got currupted, I restored all the user databases and restored the logins through login scripts. But the problem is, my packages are missing. Is there any possiblity to retrive the DTS pacakges any how? -Johnson
Sorry, no answer, but probably you find a solution onhttp://www.sqldts.com —
Microsoft SQL Server MVP
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)
PLease post thread in relevant forums. Referhttp://www.databasejournal.com/features/mssql/article.php/3417651 for more information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Do you have msdb database backup?
yes, we have msdb database
I never had to solve that issue, but I know that local dts packages are stored in [msdb].[dbo].[sysdtspac kages] table. See: http://www.sqldts.com/default.aspx?204