Post reply

Move a DTS Package

  • January 26, 2007 at 3:10 pm

    #68697

    I've created a DTS package through Enterprise Manager in SQL 2000 and would like to move this package to another system that is running SQLExpress 2005 for testing.  How can I accomplish this?

  • January 26, 2007 at 9:03 pm

    #686007

    DTS does not exist in SQL Server Express 2005. You would have to use a higher version of SQL Server 2005 or use SQL Server 2000.

    Here is a link with more information. Read down the page to "Support for SQL Server 2000 DTS Packages in SQL Server 2005 Express Edition":

    http://msdn2.microsoft.com/en-us/library/ms143706.aspx#

    Cheers,

    Diane

  • January 29, 2007 at 5:13 am

    #686105

    There is a backwards compatibility utiltiy that allows DTS packages to run via a command line utility under SQL Express

  • January 29, 2007 at 6:40 am

    #686121

    Export the package to a structured storage file and move the file to an accessable location to the second server.

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

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