posted on Wednesday, September 12, 2007 12:21 PM by bknight

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

Comments

# re: Migrating DTS packages to SSIS

Tuesday, October 30, 2007 8:02 AM by bgregory
Our organization has 37 DTS packages that need to be migrated. Several quite complex and critical to our finance dept. I'd like to evaluate this software but I am unable join the site to download the trial.

This has great potential to save us thousands in consulting costs!

Thanks!

-Brian G.