How to: Ensure Support for Data Transformation Services Packages

  • Article

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

You can run SQL Server 2000 Data Transformation Services (DTS) packages and Integration Services packages on the same computer.

When you select Integration Services for installation, Setup also installs support for SQL Server 2000 Data Transformation Services (DTS) packages, including the DTS runtime and DTS package enumeration in SQL Server Management Studio. Run-time support has been updated to enable DTS packages to access SQL Server 2005 data sources. If you are not installing Integration Services, but you need support for DTS packages, you must ensure that Legacy Components is selected on the Feature Selection page.

Note

There is no 64-bit design-time or run-time support for Data Transformation Services (DTS) packages that were created in earlier versions of SQL Server. For more information, see SQL Server 2005 Integration Services Backward Compatibility.

The backward compatibility files that are installed also include the SQL Server 2000 Analysis Services Processing task and its dependency, Decision Support Objects (DSO). However they do not include the SQL Server 2000 Data Mining Prediction Query task.

Note

DTS packages cannot be opened or edited directly in Business Intelligence Development Studio. In addition, SQL Server 2005 does not install the DTS package designer for editing DTS packages. However, you can download and install an updated version of the DTS package designer, and use this updated version to modify DTS packages. To download the updated DTS package designer, visit the Web page, Feature Pack for Microsoft SQL Server 2005, and then download the Microsoft SQL Server 2000 DTS Designer Components. After installing this download, you can view and edit DTS packages from Management Studio, or from the Execute DTS 2000 Package Task Editor in Business Intelligence Development Studio.

When you select Integration Services for installation, the Package Migration Wizard is also installed. You can optionally use the Package Migration Wizard to upgrade SQL Server 2000 DTS packages to the Integration Services format. During migration, the wizard copies the DTS packages and then re-creates them in the Integration Services format. The source packages are left intact and are not modified. For more information, see Migrating Data Transformation Services Packages.

Note

The Package Migration Wizard is available in the Standard, Enterprise, and Developer Editions of SQL Server 2005.

SQL Server 2005 Express Edition does not include Integration Services or support for SQL Server 2000 DTS packages.

  • To run existing DTS packages on a SQL Server 2005 Express Edition server, you must leave the SQL Server 2000 client tools or the DTS redistributable files on the server, or reinstall them. SQL Server 2005 Express Edition does not include the DTS runtime.
  • To edit existing DTS packages on a SQL Server 2005 Express Edition server, you must use SQL Server 2000, or edit them remotely from a server running SQL Server 2005 Workgroup, Standard, Enterprise, or Developer Edition. SQL Server 2005 Express Edition does not include SQL Server Management Studio or Business Intelligence Development Studio.
  • To migrate existing DTS packages to SQL Server 2005 Integration Services, you must use SQL Server 2005 Standard, Enterprise, or Developer Edition. Other editions of SQL Server 2005 do not include the Integration Services Package Migration Wizard.

The Import and Export Utility that is included with SQL Server 2005 Express Edition is not the SQL Server Import and Export Wizard and does not use Integration Services.

To ensure support for Data Transformation Services packages

  • Install SQL Server 2005, including Integration Services, by using the preferred method. When you select Integration Services for installation, Setup also installs support for SQL Server 2000 Data Transformation Services (DTS) packages.

See Also

Tasks

How to: Install Integration Services by Using Setup
How to: Install Integration Services from the Command Prompt

Help and Information

Getting SQL Server 2005 Assistance