Chapter 4. Containers and Data Flow

In the last chapter you were introduced to the Package Designer. In this chapter, you'll continue along those lines with an exploration of the Control Flow tab and spend most of your time in the Data Flow task. The Data Flow task is where the bulk of your data heavy lifting will occur. This chapter walks you through how each transformation in the Data Flow task can help you move and clean your data.

Get Professional 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.