OLE DB Source Editor (Error Output Page)
Use the Error Output page of the OLE DB Source Editor dialog box to select error handling options and to set properties on error output columns.
To learn more about the OLE DB source, see OLE DB Source.
Options
- 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 OLE DB 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:Handling Errors 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.
See Also
Reference
OLE DB Source Editor (Connection Manager Page)
OLE DB Source Editor (Columns Page)
Other Resources
Integration Services Error and Message Reference
How to: Extract Data Using the OLE DB Source
OLE DB Connection Manager