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.

To upgrade from Data Transformation Services to Integration 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.

    Note

    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.

See Also

Tasks

How to: Ensure Support for Data Transformation Services Packages

Concepts

SQL Server 2005 Integration Services Backward Compatibility

Help and Information

Getting SQL Server 2005 Assistance