CDC Source Editor (Error Output Page)

CDC Source Editor (Error Output Page)

 

Applies To: SQL Server 2016

Use the Error Output page of the CDC Source Editor dialog box to select error handling options.

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

To open the CDC Source Editor Error Output 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 Error Output.

Input/Output
View the name of the data source.

Column
View the external (source) columns that you selected on the Connection Manager page of the CDC Source Editor dialog box.

Error
Select how the CDC source should handle errors in a flow: ignore the failure, redirect the row, or fail the component.

Truncation
Select how the CDC source should handle truncation in a flow: ignore the failure, redirect the row, or fail the component.

Description
Not used.

Set this value to selected cells
Select how the CDC source handles all selected cells when an error or truncation occurs: ignore the failure, redirect the row, or fail the component.

Apply
Apply the error handling options to the selected cells.

You use the following options to configure how the CDC source handles errors and truncations.

Fail Component
The Data Flow task fails when an error or a truncation occurs. This is the default behavior.

Ignore Failure
The error or the truncation is ignored and the data row is directed to the CDC source output.

Redirect Flow
The error or the truncation data row is directed to the error output of the CDC source. In this case the CDC source error handling is used. For more information, see CDC Source.

CDC Source Editor (Connection Manager Page)
CDC Source Editor (Columns Page)

Community Additions

ADD
Show:
© 2016 Microsoft