ODBC Destination Editor (Error Output Page)

 

Applies To: SQL Server 2016

Use the Error Output page of the ODBC Destination Editor dialog box to select error handling options.

To learn more about the ODBC destination, see ODBC Destination.

To open the ODBC Destination Editor Error Output Page

  • In SQL Server Data Tools, open the SQL Server 2016 Integration Services (SSIS) package that has the ODBC destination.

  • On the Data Flow tab, double-click the ODBC destination.

  • In the ODBC Destination Editor, click Error Output.

Input/Output

View the name of the data source.

Column

Not used.

Error

Select how the ODBC destination should handle errors in a flow: ignore the failure, redirect the row, or fail the component.

Truncation

Select how the ODBC destination should handle truncation in a flow: ignore the failure, redirect the row, or fail the component.

Description

View a description of the error.

Set this value to selected cells

Select how the ODBC destination 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 ODBC destination 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.

Redirect Flow

The row that is causing the error or the truncation is directed to the error output of the ODBC destination. For more information, see ODBC Destination.

ODBC Destination Editor (Connection Manager Page)
ODBC Destination Editor (Mappings Page)

Community Additions

ADD
Show: