Export (0) Print
Expand All

How to: Upgrade from Data Transformation Services to Integration Services

SQL Server 2000 Data Transformation Services (DTS) packages can continue to run alongside SQL Server 2005 Integration Services (SSIS) packages.

For more information about the upgrade and migration options available to users of Data Transformation Services, see Upgrading or Migrating Data Transformation Services.

  1. Install SQL Server 2005, including Integration Services, by using the preferred method. For more information, see How to: Install Integration Services by Using Setup or How to: Install Integration Services from the Command Prompt.

  2. Integration Services also installs support for SQL Server 2000 Data Transformation Services (DTS), including the ability to enumerate and run DTS packages. For more information, see How to: Ensure Support for Data Transformation Services Packages.

    ms143284.note(en-US,SQL.90).gifNote:
    Although support for SQL Server 2000 Data Transformation Services (DTS) is installed automatically when you select Integration Services for installation, some of the registry and environment settings required by DTS are removed if you upgrade the last instance of SQL Server 2000 on the computer to SQL Server 2005 during or after setup. To restore these settings, locate "Microsoft SQL Server 2005 Backward compatibility" in the Add or Remove Programs list in the Control Panel, click the Change button, and select the Repair option on the Program Maintenance page of the wizard.

  3. Optionally, you can migrate DTS packages to the Integration Services format while leaving the original packages intact. For more information, see Migrating Data Transformation Services Packages. The Package Migration Wizard is installed when Integration Services is installed.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft