Chapter 12. Migrating to Integration Services

In This Chapter

Upgrade Advisor

Migration Options

Embedding DTS 2000 Packages in Integration Services Packages

Migrating DTS 2000 Packages to Integration Services

Summary

After having worked with various components of Integration Services such as Control Flow tasks, Data Flow transformations, connection managers, variables, property expressions, and package configurations, you should be confident in knowing that Integration Services is totally different from Data Transformation Services of SQL Server 2000. Integration Services is not an upgrade of DTS rather it is altogether a new tool.

For one thing, Data Transformation services have been deprecated from SQL Server 2005 and are no longer supported. ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.