Post reply

DTS Packages

  • February 24, 2007 at 7:00 am

    #172401

    I had SQL Server 2000 on my system which earlier contains few DTS Packages. Somehow my Windows crashed and I reinstalled it due to which my SQL Server stopped working. Now when I had reinstalled SQL Server too, those DTS Packages are not available. How could I retrieve them. I had already saved the earlier installed folder Microsoft SQL Server from Program Files Folder.

  • February 25, 2007 at 7:44 pm

    #691645

    By default, when you save a DTS package it is saved to location "SQL Server". I am assuming that this is what you did with your first SQL Server installation.

    These packages will have been saved to tabel "sysdtspackages" in the msdb database. I assume that you still have the mdb and ldb for the old msdb database.

    Attach these as another name (e.g. msdbOld) and then run the following

    Insert into mdbo..sysdtspackages

    Select * from msdbold..sysdtspackages.

  • February 25, 2007 at 11:52 pm

    #691658

    After sql installation, if you have the backup of MSDB database you can restore on top of new msdb database...

    When you restore msdb database you get all your dts packages, jobs, alerts and operators etc...

    Don't you need jobs information too

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 3 posts - 1 through 3 (of 3 total)

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