Export (0) Print
Expand All
0 out of 4 rated this helpful - Rate this topic

Excel Source Editor (Error Output Page)

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

To learn more about the Excel source, see Excel Source.

Input or Output

View the name of the data source.

Column

View the external (source) columns that you selected on the Connection Manager page of the Excel 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.