Part III: Data Flow

Lesson 14: Extracting Data from Sources

Lesson 15: Loading Data to a Destination

Lesson 16: Changing Data Types with the Data Conversion Transform

Lesson 17: Creating and Replacing Columns with the Derived Column Transform

Lesson 18: Rolling Up Data with the Aggregate Transform

Lesson 19: Ordering Data with the Sort Transform

Lesson 20: Joining Data with the Lookup Transform

Lesson 21: Auditing Data with the Row Count Transform

Lesson 22: Combining Multiple Inputs with the Union All Transform

Lesson 23: Cleansing Data with the Script Component

Lesson 24: Separating Data with the Conditional Split Transform

Lesson 25: Altering Rows with the OLE DB Command Transform

Lesson 26: Handling Bad Data with the Fuzzy Lookup Transform

Lesson 27: Removing Duplicates with the Fuzzy Grouping Transform