ADO NET Source Editor (Error Output Page)

 

Applies To: SQL Server 2016

Use the Error Output page of the ADO NET Source Editor dialog box to select error handling options and to set properties on error output columns.

To learn more about the ADO NET source, see ADO NET Source.

To open the Error Output page

  1. In SQL Server Data Tools (SSDT), open the Integration Services package that has the ADO NET source.

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

  3. In the ADO NET 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 ADO NET Source Editor dialog box.

Error
Specify what should happen when an error occurs: ignore the failure, redirect the row, or fail the component.

Related Topics: Error Handling in Data

Truncation
Specify what should happen when a truncation occurs: ignore the failure, redirect the row, or fail the component.

Description
View the description of the error.

Set this value to selected cells
Specify what should happen to all the selected cells when an error or truncation occurs: ignore the failure, redirect the row, or fail the component.

Apply
Apply the error handling option to the selected cells.

ADO NET Source Editor (Connection Manager Page)
ADO NET Source Editor (Columns Page)
ADO.NET Connection Manager

Community Additions

ADD
Show: