Integration Services Upgrade Tips

For SQL Server 2000, the process to develop and deploy DTS Packages for the most part is handled within Enterprise Manager. With SQL Server 2005, SSIS functionally follows the same general steps, but the detailed process is much different. For example, development is completed in a separate tool from the deployment.

When converting DTS packages from SQL Server 2000 to SQL Server 2008 you may encounter this error message: "The Package Migration Wizard requires the SQL Server 2000 Data Transformation Services (DTS) runtime. To install the DTS runtime, run the SQL Server Installation Wizard. On the Components to Install page, click Advanced, then select Legacy Components for installation." The first thought is to run the SQL Server setup process, but after you go through the initial setup screens you find out that there is no Advanced page, so how do you do this? In this tip we show you how to resolve this issue.

With as many Data Transformation Services (DTS) Packages that have been developed and deployed for B2B, data integration and BI needs, when it comes to upgrading from SQL Server 2000 to 2005, this portion of the upgrade will need special attention. DTS Packages have become engrained in many applications and business processes making them business critical for not only internal applications but also mission critical for business partners. In addition, DTS Packages are probably being used in unexpected ways than originally intended further complicating the upgrade process. In some respects DTS Packages being called directly from web pages or being automatically triggered based on a business event follow a much different paradigm than those

For SQL Server 2000, the process to develop and deploy DTS Packages for the most part is handled within Enterprise Manager. With SQL Server 2005, SSIS functionally follows the same general steps, but the detailed process is much different. For example, development is completed in a separate tool from the deployment.

With as many Data Transformation Services (DTS) Packages that have been developed and deployed for B2B, data integration and BI needs, when it comes to upgrading from SQL Server 2000 to 2005, this portion of the upgrade will need special attention. DTS Packages have become engrained in many applications and business processes making them business critical for not only internal applications but also mission critical for business partners. In addition, DTS Packages are probably being used in unexpected ways than originally intended further complicating the upgrade process. In some respects DTS Packages being called directly from web pages or being automatically triggered based on a business event follow a much different paradigm than those

When converting DTS packages from SQL Server 2000 to SQL Server 2008 you may encounter this error message: "The Package Migration Wizard requires the SQL Server 2000 Data Transformation Services (DTS) runtime. To install the DTS runtime, run the SQL Server Installation Wizard. On the Components to Install page, click Advanced, then select Legacy Components for installation." The first thought is to run the SQL Server setup process, but after you go through the initial setup screens you find out that there is no Advanced page, so how do you do this? In this tip we show you how to resolve this issue.

When converting DTS packages from SQL Server 2000 to SQL Server 2008 you may encounter this error message: "The Package Migration Wizard requires the SQL Server 2000 Data Transformation Services (DTS) runtime. To install the DTS runtime, run the SQL Server Installation Wizard. On the Components to Install page, click Advanced, then select Legacy Components for installation." The first thought is to run the SQL Server setup process, but after you go through the initial setup screens you find out that there is no Advanced page, so how do you do this? In this tip we show you how to resolve this issue.

With as many Data Transformation Services (DTS) Packages that have been developed and deployed for B2B, data integration and BI needs, when it comes to upgrading from SQL Server 2000 to 2005, this portion of the upgrade will need special attention. DTS Packages have become engrained in many applications and business processes making them business critical for not only internal applications but also mission critical for business partners. In addition, DTS Packages are probably being used in unexpected ways than originally intended further complicating the upgrade process. In some respects DTS Packages being called directly from web pages or being automatically triggered based on a business event follow a much different paradigm than those

For SQL Server 2000, the process to develop and deploy DTS Packages for the most part is handled within Enterprise Manager. With SQL Server 2005, SSIS functionally follows the same general steps, but the detailed process is much different. For example, development is completed in a separate tool from the deployment.