Share via


OLE DB Destination Editor (Error Output Page)

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.

Options

  • 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:Handling Errors 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.

See Also

Reference

OLE DB Destination Editor (Connection Manager Page)
OLE DB Destination Editor (Mappings Page)

Other Resources

Integration Services Error and Message Reference
How to: Load Data Using the OLE DB Destination

Help and Information

Getting SQL Server 2005 Assistance