DTS support in SQL Server 2008 consists of multiple components, as described in the topic, Support for Data Transformation Services (DTS) in SQL Server 2008. Although Setup can install some of these components, those components are not fully functional until you install DTS run-time support. To install Integration Services together with all the features that support for DTS requires, you have to install multiple items as described in the following procedure.

 To install all the features of DTS support

1. During Setup, on the Feature Selection page, make the following selections:

   1. Select Integration Services.
      This option installs the ActiveX Script task and the DTS Package Migration Wizard.
      
   2. Select Client Tools Backward Compatibility.
      This option installs the Execute DTS 2000 Package task.
      

2. After Setup, install the DTS runtime as described in this sections, "Installing Run-time Support for DTS Packages on a 32-bit Computer" and "Installing Run-time Support for DTS Packages on a 64-bit Computer," later in this topic.

3. (Optional) After Setup, install the DTS designer as described in the section, "Installing Design-time Support for DTS Packages," later in this topic.

SQL Server 2008 does not install run-time support for DTS packages. Before you can run and manage DTS packages, you have to install this run-time support as described in the following procedure.

 To install run-time support for Data Transformation Services packages on a 32-bit computer

• On the installation media that you used to install SQL Server 2008, locate and run the version of the SQLServer2005_BC*.msi Windows Installer package that is appropriate for the operating system.

  —or—

• In an Internet browser, open the Microsoft SQL Server 2008 Feature Pack page, and then download and install the Microsoft SQL Server 2005 Backward Compatibility Components.

There is no 64-bit run-time support for DTS packages. On a 64-bit computer, DTS packages, and Integration Services packages that run DTS packages, can run only in 32-bit mode. To run packages in 32-bit mode outside BI Development Studio on a 64-bit computer, you have to install the 32-bit version of the Integration Services runtime and command prompt utilities.

 To install the 32-bit version of the Integration Services runtime and command prompt utilities on a 64-bit x86 computer

• During Setup, select Business Intelligence Development Studio or Management Tools - Complete.

  Selecting either of these options installs the 32-bit version of of the Integration Services runtime, the dtexec utility (dtexec.exe), and other Integration Services tools.

SQL Server 2008 does not install design-time support for DTS packages. Before you can use the SQL Server 2008 tools to open and view DTS packages, you have to download and install this design-time support as described in the following procedure.

Note:
The DTS package designer that you can download works with the SQL Server 2008 tools, but the designer's features have not been updated for SQL Server 2008.

 To install design-time support for Data Transformation Services packages

• In an Internet browser, open the Feature Pack for Microsoft SQL Server 2005 Web page, and then download and install the Microsoft SQL Server 2000 DTS Designer Components.