Chapter 11. Migrating from DTS to SSIS
The SQL Server perfect storm is about to approach. SQL Server 2005 does still support Data Transformation Services (DTS) from a runtime perspective, but the next release of SQL Server may not. This gives you a small window of opportunity to upgrade your packages from DTS to SSIS using SQL Server 2005. This chapter discusses first how to run DTS from within a SQL Server 2005 environment, and then how to upgrade your DTS packages to SSIS. The first part of this process can be done through a wizard, but the conversion doesn't stop when the package is migrated.
Get Expert SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
