SSIS: The Data Flows Part 2
SSIS Data Flows Part 2 builds on SSIS Data Flows Part 1 by adding a correlating Lookup and subsequent Conditional Split transformations to prevent data re-loading, or loading duplicates. This addition introduces the first order of an Incremental Load SSIS design pattern that Andy calls “Forward-Only Incremental Load.”
Lessons
Data Flows 2 Lecture
Data Flows Demo
Create a Real Data Flow
Access lesson material and instruction here