How to restore a DTS package in SQL Server 2000
Posted on 2008-10-20
I accidentally deleted a DTS package from SQL Server 2000, how can I get it back?
I tried restoring the msdb database to msdb_test and then went to the sysdtspackages table and copied the dts from there and pasted it to the msdb database.
Now, you can see the DTS in the list but when you try to run it, the following error appears:
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: No data for the specified Package was retrieved from the specified SQL Server.
Any ideas? Thank you in advance.