SQL Server Performance Forum – Threads Archive
How to restore DTS Pacakges
Dear 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? -JohnsonSorry, no answer, but probably you find a solution onhttp://www.sqldts.com —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
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
Moderator
http://www.SQL-Server-Performance.Com/forum
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
]]>