OLE DB Destination Editor (Error Output Page)

 

Applies To: SQL Server 2016

Use the Error Output page of the OLE DB Destination Editor dialog box to specify error handling options.

To learn more about the OLE DB destination, see OLE DB Destination.

Input/Output
View the name of the input.

Column
Not used.

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
Not used.

Description
View the description of the operation.

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.

Integration Services Error and Message Reference
OLE DB Destination Editor (Connection Manager Page)
OLE DB Destination Editor (Mappings Page)
Load Data by Using the OLE DB Destination

Community Additions

ADD
Show: