<div>
there are several dts tables in msdb. &nbsp;You'll need to find all of the entries and move them. &nbsp;Even then you might have issues. &nbsp;what I woud do is restore your msdb backup to a different instance as msdb, not msdb_test. &nbsp;The package should show up in EM in that instance. &nbsp;Then you can save it to the other instance. &nbsp;<br />
<br />

</div>


there are several dts tables in msdb.  You'll need to find all of the entries and move them.  Even then you might have issues.  what I woud do is restore your msdb backup to a different instance as msdb, not msdb_test.  The package should show up in EM in that instance.  Then you can save it to the other instance.  



<div>
Thanks for the reply randy.<br />
<br />
I don't quite understand, I should restore my backup of msdb over my existing msdb?
</div>


Thanks for the reply randy.

I don't quite understand, I should restore my backup of msdb over my existing msdb?

<div>
I only have 1 SQL Server, how can I create another instance?
</div>


I only have 1 SQL Server, how can I create another instance?

<div>
Nevermind I got it. Thanks Randy.
</div>


<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
I accidentally deleted a DTS package from SQL Server 2000, how can I get it back?<br />
<br />
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.<br />
<br />
Now, you can see the DTS in the list but when you try to run it, the following error appears:<br />
<br />
Error Source: Microsoft Data Transformation Services (DTS) Package<br />
Error Description: No data for the specified Package was retrieved from the specified SQL Server.<br />
<br />
Any ideas? Thank you in advance.
</div>
</div>


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

How to restore a DTS package in SQL Server 2000

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.