Summary

In this chapter, you’ve learned some of the good, the bad, and the ugly of migrating DTS packages to SSIS. The DTS Migration Wizard does a good job of migrating the core package, but leaves out many issues that need to be addressed. That’s where most of the work occurs, and you’ll sometimes find yourself throwing away the migrated package and starting again from scratch.

Chapter 12 discusses how to scale and performance tune SSIS.