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

  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 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.

  3. (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

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.

Note

On a 64-bit computer, substitute %ProgramFiles(x86)% for %ProgramFiles% in the following procedures.

To ensure that the DTS designer can be used in SQL Server Management Studio

  1. Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE folder.

  2. Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id% folder. For example, for U.S. English, the lang_id subfolder will be "1033".

To ensure that the DTS designer can be used in Business Intelligence Development Studio

  1. Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE folder.

  2. Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources folder to the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\%lang_id% folder. For example, for U.S. English, the lang_id subfolder will be "1033".