Chapter 12: DTS 2000 Migration and Metadata Management

Overview

By now, you are probably pretty familiar with various basic aspects of SSIS. In earlier chapters, you've studied the new SSIS interface, the new object model, internal design, and how to write SSIS packages.

In this chapter, you will look at how to migrate DTS 2000 packages to SSIS and, if necessary, how to run DTS 2000 packages under SSIS. You will also learn about some advanced settings in SSIS, such as metadata management and managing DTS 2000 packages in SSMS.