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.

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:
SQL Server 2005 does not install the DTS package designer for editing DTS packages. For more information, see SQL Server 2005 Integration Services Backward Compatibility. DTS packages cannot be opened or edited in BI 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

See Also