CDC Source Editor (Columns Page)


Applies To: SQL Server 2016

Use the Columns page of the CDC Source Editor dialog box to map an output column to each external (source) column.

To learn more about the CDC source, see CDC Source.

To open the CDC Source Editor Columns Page

  1. In SQL Server Data Tools, open the SQL Server 2016 Integration Services (SSIS) package that has the CDC source.

  2. On the Data Flow tab, double-click the CDC source.

  3. In the CDC Source Editor, click Columns.

Available External Columns
A list of available external columns in the data source. You cannot use this table to add or delete columns. Select the columns to use in the source. The selected columns are added to the External Column list in the order they are selected.

External Column
A view of the external (source) columns in the order that you see them when configuring components that consume data from the CDC source. To change this order, first clear the selected columns in the Available External Columns list, and then select external columns from the list in a different order. The selected columns are added to the External Column list in the order you select them.

Output Column
Enter a unique name for each output column. The default is the name of the selected external (source) column, however you can choose any unique, descriptive name. The name entered is displayed in the SSIS Designer.

CDC Source Editor (Connection Manager Page)
CDC Source Editor (Error Output Page)

Community Additions