September 2007 - Posts

Migrating DTS packages to SSIS

I've been working for years on developing patterns for migrating DTS packages to SSIS. Finally, we're in the final few weeks of QA work on a new product called DTS xChange that will migrate DTS packages to SSIS and apply best SSIS practices to the package. This product also migrates items that the existing wizard will not migrate such as Dynamic Properties Tasks and connections that use UDL files. It also applies a series of SSIS rules during the conversions like turning on logging. See more information here: http://www.pragmaticworks.com/dtsxchange.htm