Chapters 1 and 2 have given you an overview of SSIS and the core architecture of both SQL Server and SSIS. This chapter is
a guide to transitioning from DTS to SSIS. It explains
| |
• How SSIS handles tasks you now do with DTS |
| |
• How you can do the same things more efficiently using some of SSIS’s new features |
| |
• The best way to migrate your existing hard work with DTS into shiny new SSIS packages. |