Section 3
Data Flow
- Lesson 18: Extracting Data from Sources
- Lesson 19: Loading Data to a Destination
- Lesson 20: Changing Data Types with the Data Conversion Transform
- Lesson 21: Creating and Replacing Columns with the Derived Column Transform
- Lesson 22: Rolling Up Data with the Aggregate Transform
- Lesson 23: Ordering Data with the Sort Transform
- Lesson 24: Joining Data with the Lookup Transform
- Lesson 25: Auditing Data with the Row Count Transform
- Lesson 26: Combining Multiple Inputs with the Union All Transform
- Lesson 27: Cleansing Data with the Script Component
- Lesson 28: Separating Data with the Conditional Split Transform
- Lesson 29: Altering Rows with the OLE DB Command Transform
- Lesson 30: Handling Bad Data with the Fuzzy Lookup Transform
- Lesson 31: Removing Duplicates with the Fuzzy Grouping Transform
Get Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer 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.