Direct the CDC Stream According to the Type of Change
Applies To: SQL Server 2016
To add and configure a CDC splitter Transformation, the package must contain at least one Data Flow task and a CDC source.
The CDC source added to the package must have a NetCDC processing mode selected. For more information on selecting processing modes, see CDC Source Editor (Connection Manager Page).
In SQL Server Data Tools, open the SQL Server 2016 Integration Services (SSIS) project that contains the package you want.
In the Solution Explorer, double-click the package to open it.
Click the Data Flow tab, and then from the Toolbox, drag the CDC splitter to the design surface.
Connect the CDC source that is included in the package to the CDC Splitter.
Connect the CDC splitter to one or more destinations. You can connect up to three different outputs.
Select one of the following outputs:
Delete output: The output where DELETE change rows are directed.
Insert output: The output where INSERT change rows are directed.
Update output: The output where before/after UPDATE change rows and Merge change rows are directed.
Optionally, you can configure the advanced properties using the Advanced Editor dialog box.
The Advanced Editor dialog box contains the properties that can be set programmatically.
To open the Advanced Editor dialog box:
- In the Data Flow screen of your SQL Server 2016 Integration Services (SSIS) project, right click the CDC splitter and select Show Advanced Editor.
For more information about using the CDC splitter see CDC Components for Microsoft SQL Server Integration Services.