Dans cet article

04/29/2015

5 minutes de lecture

Dans cet article

Considerations for Upgrading Data Transformation Services

If SQL Server 2000 Data Transformation Services (DTS) is currently installed on your computer, you can upgrade from Data Transformation Services to SQL Server 2008 Integration Services without any software conflicts. There are no software conflicts because Integration Services is a completely new product and not a version upgrade from Data Transformation Services.

After upgrading, you can optionally use the DTS Package Migration Wizard to migrate DTS packages to the Integration Services format. During migration, the wizard copies 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 DTS Package Migration Wizard is available in the following editions of SQL Server: Standard, Enterprise, and Developer.

It is not possible to use SQL Server 2008 Setup to upgrade directly from SQL Server 6.5 or 7.0 to SQL Server 2008.

When you upgrade, you can upgrade both DTS and the Database Engine, just upgrade DTS, or just upgrade the Database Engine. If you upgrade only DTS or only the Database Engine, there are some limitations:

If you upgrade only DTS, SQL Server 2008 Integration Services is fully functional. However, Integration Services will only be able to store packages in the file system, unless an instance of the SQL Server 2008 Database Engine is available on another computer. If an instance of the SQL Server 2008 Database Engine is available, Integration Services will be able to store packages in that instance.

If you upgrade only the Database Engine, DTS remains functional. However, you will not have the functionality of Integration Services.

Upgrading Both Data Transformation Services and the Database Engine to SQL Server 2008

This section describes the effects of performing an upgrade that has the following criteria:

You upgrade both DTS and an instance of the Database Engine to SQL Server 2008.

Both DTS and the instance of the Database Engine to be upgraded are on the same computer.

What the Upgrade Process Does

The upgrade process does the following tasks:

Upgrades the instance of the Database Engine to SQL Server 2008.

Installs SQL Server 2008 Integration Services.

Installs updated run-time support for DTS packages. This support includes the DTS runtime and DTS package enumeration in SQL Server Management Studio. DTS packages can continue to run alongside Integration Services packages on the same computer. For more information, see How to: Install Support for Data Transformation Services Packages.

Leaves existing DTS packages intact in the existing DTS system tables in the msdb database.

What the Upgrade Process Does Not Do

The upgrade process does not do the following tasks:

Does not migrate existing DTS packages to the format that Integration Services packages use. After upgrading, you can optionally use the DTS Package Migration Wizard to migrate DTS packages to the Integration Services format. During migration, the wizard copies DTS packages and then re-creates them in the Integration Services format. The source packages are left intact and are not modified.

When you install Integration Services, Setup also installs the DTS Package Migration Wizard.

Note

The DTS Package Migration Wizard is available in the Standard, Enterprise, and Developer Editions of SQL Server.

After installing the optional run-time support for DTS, you can do the following tasks:

To view DTS packages under the Management\Legacy\Data Transformation Services node in SQL Server Management Studio, connect to the upgraded instance of the Database Engine. (When you connect to the Integration Services service, you can only view Integration Services packages.)

To run DTS packages within an Integration Services package, use the Execute DTS 2000 Package task. For more information, see Execute DTS 2000 Package Task.

To run DTS packages at the command prompt, use the dtsrun.exe utility.

To run DTS packages from SQL Server Agent jobs, call the dtsrun.exe utility from a job step.