CDC control task can be synchronized from controlling CDC data, such as initialization load, LSN scope management. It can be a substitute for another approach, which is to do the same thing by calling a batch of CDC functions. From the perspective of SSIS, things are easy to program, and with the other two spaces (CDC Source, and CDC Splitter), only a few control parameters can be configured to complete the data extraction process.
CDC source queries data from a CDC-enabled data table
The CDC splitter and conditional split components feature similar features. It generates three branches of data flow: Inserts, Updates, and deletions
Loading CDC data typically requires two packages, one to do initial load and the other to do incremental load.
When it comes to CDC control Task, you need to state that the CDC control Operation property has 4 options:
1) Mark Initial load start:initial load start to get the start LSN and update cdc_state variable values
2) Mark Initial load end:initial load at the end of the Get start LSN and update cdc_state variable value
3) Mark CDC start: Record CDC range start value
4) Get processing range: Gets the LSN range value at incremental load
5) Mark processed range: The LSN range value after the incremental load is completed
Data Flow->> CDC Control Task, CDC Source, CDC Splitter