Post reply

Copy a DTS Package to another SQL Server

  • April 16, 2003 at 11:55 pm

    #159656

    How is a DTS Package copied to another SQL Server?

    Why do I want to do this? The DTS Package was developed on a development server and I want to move it to the production server.

  • April 17, 2003 at 4:00 am

    #454475

    You could save the package as a "Structured Storage File". (check BOL for "Structured Storage")

  • April 17, 2003 at 8:26 am

    #454544

    open the dts in development server

    clik the menu 'package','save as' and select the

    SQL server you want to copy.

    Regards

    Joseph

  • April 17, 2003 at 8:32 am

    #454549

    Is there anyway to move several DTS packages at once? Rather than opening each one and doing a 'save as' to the new server?

  • May 8, 2003 at 2:57 am

    #456490

    There is a utility on

    http://www.sqldts.com called DTSBackup2000

    that does exactly what you need

Viewing 5 posts - 1 through 4 (of 4 total)

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