Brains Up AnalyticsBRAINSUPAnalytics

CDC in SSIS in Practice

Turn full loads into incremental loads without scanning the whole table

The complete Change Data Capture pattern inside SSIS: from the CDC Control Task to LSN-based state, net changes, delete handling and idempotency for safe re-runs. Ready-to-adapt code and a final checklist that closes the loop. (Content in Portuguese.)

What you get

  • 17 dense pages written by someone who has done ETL for nearly 20 years
  • Incremental package template (full Control Flow)
  • SQL scripts for enablement, net changes and MERGE
  • Implementation and troubleshooting checklist

Contents

  1. 1The question that changes everything: "what changed?"
  2. 2How CDC works under the hood (LSN)
  3. 3Enabling CDC and choosing net changes
  4. 4The CDC Control Task and LSN-based state
  5. 5Applying the delta with MERGE (including deletes)
  6. 6Idempotency, monitoring and 2026 alternatives