Post reply

Moving DTS Packages saved on SQL Server

  • July 16, 2004 at 8:25 am

    #83321

    Hi,

    I generally save my DTS packages on my SQL Server.  They are pretty complicated with >30 fields.  I would like to save a copy to put on another SQL Server (and then change only the from and to) but not the rest.  Is this possible?  How do they get backed up if at all?

    Thanks,

    LogicMagic

  • July 17, 2004 at 7:55 pm

    #514997

    There are several ways to do this.

    1.  You can just backup/restore the msdb database.  This will migrate all jobs and DTS packages to the other server. 

    2.  You can click on each of the DTS packages and save as a Structured File.  You can then copy them wherever you want them (SourceSafe for example would be a great choice).  To restore them to another SQL Server, simply right-click on Data Transformation Services, click on Open Packages, open the package of your choice, then save as back to the SQL Server of your choice.  WahLah...you have now migrated it and have a neat little file to copy if you want.

    3.  You can open the DTS package, click save as, and just save it to the other SQL Server provided you can see it from the originating SQL Server.

     

     

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

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

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