Article
02/06/2012

How to: Install Support for Data Transformation Services Packages

Although SQL Server 2000 Data Transformation Services (DTS) is deprecated, you can continue to run DTS packages alongside Integration Services packages on the same computer. (For more information, see Support for SQL Server 2000 DTS in SQL Server 2008 R2. For more information about the deprecation of DTS, see Data Transformation Services (DTS).)

When planning to install support for DTS packages, know that SQL Server 2008 does not include support for DTS in the following circumstances:

There is no 64-bit design-time or run-time support for DTS packages. On a 64-bit computer, DTS packages, and Integration Services packages that use the Execute DTS 2000 Package task to run DTS packages, can run only in 32-bit mode.
There is no design-time or run-time support for DTS packages on Itanium-based operating systems. Therefore, you cannot create, view, modify, or run DTS packages on Itanium-based operating systems.

If you have to continue to run DTS packages alongside Integration Services packages, you can install run-time and design-time support as described in the following sections.

Installing Support for DTS Packages

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

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.
After Setup, install the DTS runtime as described in the sections, "Installing Run-time Support for DTS Packages" and "Installing Additional 32-Bit Files Required to Run DTS Packages on a 64-bit Computer," later in this topic.
(Optional) After Setup, install the DTS designer as described in the section, "Installing Design-time Support for DTS Packages," later in this topic.

Installing Run-time Support for DTS Packages

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

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.

Note

This download has not been updated for SQL Server 2008 R2.

Installing Additional 32-Bit Files Required to Run DTS Packages on a 64-bit Computer

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 following components:

The 32-bit DTS runtime, as described in the previous section.
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 the Integration Services runtime, the dtexec utility (dtexec.exe), and other Integration Services tools.

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

During Setup, select Management Tools - Complete.

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

Installing Design-time Support for DTS Packages

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 page, and then download and install the Microsoft SQL Server 2000 DTS Designer Components.

By default, on a 32-bit computer, the binary files for SQL Server 2000 are in the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder, and the binary files for SQL Server 2008 are in the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn folder. These default locations might cause the path of the binary files for SQL Server 2000 to occur in the PATH environment variable before the path of the binary files for SQL Server 2008. If this happens, an error message can appear when you try to use the DTS Designer. To resolve this error, copy the files that the designer requires to a new location as described in the following procedures.