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 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.
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