How to restore DTS Pacakges | SQL Server Performance Forums

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? -Johnson
Sorry, no answer, but probably you find a solution on
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V.

PLease post thread in relevant forums. Refer 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: