Chapter Summary

The DTS Import/Export Wizard is an excellent tool for quickly copying data between disparate data sources, and it is a powerful tool for migrating database objects and data between instances of SQL Server. It is also a good place for beginning developers to start when creating more complex data movement applications using DTS Designer. In Chapter 2, you will learn how the packages you created in this chapter actually work, and you will begin to extend their functionality.