Chapter 5

The Data Flow

WHAT’S IN THIS CHAPTER?

• Learn about the SSIS Data Flow architecture
• Reading data out of sources
• Loading data into destinations
• Transforming data with common transformations

In the last two chapters you were introduced to the Control Flow tab through tasks and containers. In this chapter, you’ll continue along those lines with an exploration of the Data Flow tab, which is where you will spend most of your time as an SSIS developer. The Data Flow Task is where the bulk of your data heavy lifting occurs in SSIS. This chapter walks you through the transformations in the Data Flow Task, demonstrating how they can help you move and clean your data. You’ll notice a few components (the CDC ones) aren’t covered in this chapter. Those needed more coverage than this chapter had room for and are covered in Chapter 12.