How to: Install Support for Data Transformation Services Packages

SQL Server Setup

Data Transformation Services (DTS) packages can continue to run alongside Integration Services packages on the same computer. For more information, see Support for Data Transformation Services (DTS) in SQL Server 2008.

To use DTS packages alongside Integration Services packages, you can install run-time and design-time support as described in the following sections.

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

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 that support DTS

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

Installing Run-time Support for DTS Packages on a 32-bit Computer

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.

Installing Run-time Support for 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 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 computer

  • During Setup, select Business Intelligence Development Studio to install 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, 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.

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

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