Recover Those Packages!

  • Comments posted to this topic are about the content posted at

  • ... " The drop down for the destination of the Transform Data Task doesn't display the system tables"


    If you are using DTS 2000, BEFORE you select the tables on your Transform Data Task, you can use the DISCONECTED EDIT feature to fill in a system table name !!!

    Noel Diaz


    Implex Corp.

    * Noel

  • Noel,

    Outstanding!!!! I didn't know this.

    Thanks for the info.

    Are you interested in writing a short "Transferring System Tables" article? If not I will, but it's a great topic.

    Steve Jones

  • I tried this on my installation of SQL Server 2000 (SP2 plus security patch 061) and it couldn't find the table. It turned out that the table name in the query was incorrect but got me pointed in the right direction. The corrected script is as follows:

    insert msdb.dbo.sysdtspackages

    select * from msdb_temp.dbo.sysdtspackages

    Thanks for the help!

    Bryant E. Byrd, MCDBA

    SQL Server DBA/Systems Engineer

    Intellithought, Inc.

    [font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
    Business Intelligence Administrator
    MSBI Administration Blog

  • Sorry for the typo, but glad we got you pointed in the right direction.

    Steve Jones

  • Steve ... the typo was minor, 1 minute annoyance in comparision to the grief I was suffering trying to remember ALL of the DTS packages I had. I too, did exactly what you did above ... and I consider myself painstainkingly anal about backups and the like. Go figure!

    Thanks for the tip - it saved my trip.


  • Yes, this is very helpful. Thanks!

    But I understand this isn't the "right" way to recover DTS packages, if you start out with a backup of it?

    I am not able to see the link for "Save a DTS Package Locally" in your article. Can you send the link again if it still exists?

    If you are copying over a whole instance to a different server, how do you transfer over the DTS packages in msdb? MSDB can't be detached.



Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply