Search code examples
ssismigrationdts

How do I convert DTS packages to SSIS packages?

I'm looking for tutorials or walkthroughs for converting DTS packages into the new SSIS 2005. Any one knows.

Solution

  • Migrating DTS Packages to Integration Services

    SQL Server Integration Services provides a robust way to process millions of rows of data. The platform is highly extensible and performs much faster than the previous DTS platform. Migration of old DTS packages can be done two ways: through the built-in Package Migration Wizard, which handles simple package migrations; and through DTS xChange, which handles both simple and complex DTS migrations, while applying best practices to the migrated packages.