Incremental Load Design Pattern
Implements the brute-force incremental-load pattern from the book 'SSIS Design Patterns': a Lookup classifies source rows as new versus existing, a Conditional Split detects whether non-key columns changed, new rows go straight to the destination, and changed rows stage to a temp table that a follow-on Execute SQL applies with a set-based UPDATE.