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.”