Migrating DTS Packages to Integration Services
A SQL Server Technical Article by Brian Knight & Dustin Ryan. SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and DBAs engineer an ETL process. Learn about the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. Download this whitepaper by Brian Knight and see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.