Migration SQL Server 2000 DTS to SSIS 2005/2008

Article
07/21/2009

Migration DTS packages to SSIS 2005/2008

Setup SSIS with DTS 2000

On the migration of 2000 DTS to SSIS 2005/2008. There are many known issues in the migration of DTS 2000. It is recommended to execute the DTS inside SSIS 2005/2008 without migration. And if you need to edit a DTS in 2000 it will be better to recreate from scratch.

Known issues related to migration packages
SQL Server 2005 : https://msdn.microsoft.com/en-us/library/ms143462(SQL.90).aspx
SQL Server 2008 : https://msdn.microsoft.com/en-us/library/ms143462.aspx

Support for Data Transformation Services (DTS) in SQL Server 2008
https://msdn.microsoft.com/en-us/library/bb500440.aspx

What should I install for SSIS developers

You will find the answers in the documentation below:

Installing SQL Server Integration Services by Using Setup
SQL Server 2005 : https://msdn.microsoft.com/en-us/library/ms143510(SQL.90).aspx
SQL Server 2008 : https://msdn.microsoft.com/en-us/library/ms143510.aspx

"When you select Integration Services for installation, Setup also installs support for SQL Server 2000 Data Transformation Services (DTS) packages, including the DTS runtime and DTS package enumeration in SQL Server Management Studio. Run-time support has been updated to allow DTS packages to access SQL Server 2005 data sources. If you are not installing Integration Services, but you need support for DTS packages, then you need to make sure that Legacy Components is selected on the Feature Selection page."

There are some interesting components to you:

Microsoft SQL Server 2000 DTS Designer Components
SQL Server 2005 : https://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=fr

How to: Install Support for Data Transformation Services Packages
https://msdn.microsoft.com/en-us/library/ms143755.aspx

Microsoft SQL Server 2005 Backward Compatibility Components
SQL Server 2005 : https://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=fr
SQL Server 2008 : https://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=fr

Sample

With SQL Server Management Studio 2005/2008

Import the package DTS 2000
in SQL Instance >> Management >> Legacy >> DTS : Import

Migrate the package DTS 2000 to SSIS
package Instance >> Management >> Legacy >> DTS : Migrate wizard

Migration des packages DTS vers SSIS 2005/2008

Setup SSIS avec DTS 2000

Concernant la migration des DTS 2000 vers SSIS 2005/2008. Il existe de nombreux problèmes connus dans la migration des DTS 2000. Il est recommandé de d'exécuter les DTS 2000 dans SSIS 2005/2008 sans les migrer. Et si vous devez modifier un DTS 2000 il est préférable de le recréer.

Problèmes connus liés à la migration des packages
SQL Server 2005 : https://msdn.microsoft.com/fr-fr/library/ms143462(SQL.90).aspx
SQL Server 2008 : https://msdn.microsoft.com/fr-fr/library/ms143462.aspx

Prise en charge de DTS dans SQL Server 2008
https://msdn.microsoft.com/fr-fr/library/bb500440.aspx

Que faut-il installer pour les développeurs SSIS

Vous trouverez les éléments de réponses dans la documentation ci-dessous :

Installing SQL Server Integration Services by Using Setup
SQL Server 2005 : https://msdn.microsoft.com/fr-fr/library/ms143510(SQL.90).aspx
SQL Server 2008 : https://msdn.microsoft.com/fr-fr/library/ms143510.aspx

Il a des composants qui sont intéressants dans votre cas :

Microsoft SQL Server 2000 DTS Designer Components
SQL Server 2005 : https://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=fr

Procédure : installer la prise en charge des packages DTS
https://msdn.microsoft.com/fr-fr/library/ms143755.aspx

Exemple

Avec SQL Server Management Studio 2005/2008

Import the package DTS 2000
in SQL Instance >> Management >> Legacy >> DTS : Import

Migrate the package DTS 2000 to SSIS
package Instance >> Management >> Legacy >> DTS : Migrate wizard

Migración de paquetes DTS a SSIS 2005/2008

Setup SSIS con DTS 2000

Sobre la migración de DTS SQL Server 2000 a SSIS 2005/2008. Hay muchos problemas conocidos en la migración de DTS 2000. Se recomienda ejecutar el DTS en SSIS 2005/2008 sin la migración. Y si necesita editar un DTS serà mejor volver a crearlo.

Problemas conocidos de migración de paquetes
SQL Server 2005 : https://msdn.microsoft.com/es-es/library/ms143462(SQL.90).aspx
SQL Server 2008 : https://msdn.microsoft.com/es-es/library/ms143462.aspx

Compatibilidad con Servicios de transformación de datos de DTS en SQL Server (2008)
https://msdn.microsoft.com/es-es/library/bb500440.aspx

¿Qué debo instalar para desarrolladores SSIS?

Va a encontrar las respuestas en la documentación a continuación:

Problemas conocidos de migración de paquetes
SQL Server 2005 : https://msdn.microsoft.com/es-es/library/ms143510(SQL.90).aspx
SQL Server 2008 : https://msdn.microsoft.com/es-es/library/ms143510.aspx

Tiene componentes que son interesantes para usted:

Microsoft SQL Server 2000 DTS Designer Components
SQL Server 2005 : https://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=fr

Cómo instalar la compatibilidad con los paquetes de Servicios de transformación de datos
https://msdn.microsoft.com/es-es/library/ms143755.aspx

Ejemplo

Con SQL Server Management Studio 2005/2008

Import the package DTS 2000
in SQL Instance >> Management >> Legacy >> DTS : Import

Migrate the package DTS 2000 to SSIS
package Instance >> Management >> Legacy >> DTS : Migrate wizard

Michel Degremont | Microsoft EMEA
Product Support Services Developer - SQL Server Core Engineer |

Migration SQL Server 2000 DTS to SSIS 2005/2008

Additional resources