SQL Server 2000 DTS Migration

SSIS is the next generation of the former Microsoft Data Transformation Services (DTS) that is included within the previous versions of SQL Server. SSIS has been designed with a new, high-performance, and advanced underlying architecture. The good news is that if you already have an inventory of SQL Server Data Transformation Services (DTS) packages, all of these packages will continue to run in SSIS environments without any changes. In addition, SSIS provides the Package Migration Wizard that you can use to convert SQL Server 2000 DTS packages to SSIS packages. Because of some of the significant improvements, such as the SSIS control flow and data pipeline architectures, as well as many of the new and enhanced tasks and transformations, DTS package conversion might not always be complete and could require some final manual enhancements. You might also want to redesign some of your existing DTS packages to take advantage of the performance improvements and additional task functionality that is now available within SSIS.