CDC Splitter SSIS

Purpose-built for data engineers and ETL developers, this tool models and validates how Change Data Capture events are split and routed within SSIS pipelines. It defines a CDC event schema, routing rule engine, and default routing behavior to ensure deterministic delivery of changes to downstream targets. Conceptually, events originating from CDC feeds are evaluated against prioritized rules that map to one or more SSIS destinations, preserving source order and enabling parallel processing where appropriate. The tool emphasizes correctness, auditability, and reusability of routing configurations, supporting scenarios such as per-table routing, per-operation routing, and filters on columns or values. Unique value comes from explicit rule precedence, exportable rule sets for package templates, and integrated validation to catch conflicts before deployment. Use cases include incremental loads, multi-target replication, and staged transformations where different downstream systems require distinct CDC views. Core features include aCDC event schema, a rule engine, default routing, and auditing hooks. Outputs consist of split streams and an audit log with routing decisions and status, which helps operators verify coverage and performance. The tool targets data engineers working with SQL Server CDC and SSIS or similar ELT ecosystems, enabling faster design, fewer routing errors, and better maintainability of CDC-driven pipelines.