Chapter 4. Data Flow Task Part 2—Transformations

by Reza Rad and Pedro Perfeito

In this chapter, we will cover the following topics:

• Derived Column: adding calculated columns

• Audit Transformation: logging in Data Flow

• Aggregate Transform: aggregating the data stream

• Conditional Split: dividing the data stream based on conditions

• Lookup Transform: performing the Upsert scenario

• OLE DB Command: executing SQL statements on each row in the data stream

• Merge and Union All transformations: combining input data rows

• Merge Join Transform: performing different types of joins in Data Flow

• Multicast: creating copies of the data stream

• Working with BLOB fields: Export Column and Import Column transformations

• Slowly Changing Dimensions (SCDs) in SSIS