O'Reilly logo

Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services by Mike Davis, Devin Knight, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required