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
Get Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 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.