Flat File Source Editor (Error Output Page)

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

To learn more about the Flat File source, see Flat File 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 Flat File Source Editordialog box.

  • 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
    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

Flat File Source Editor (Connection Manager Page)

Flat File Source Editor (Columns Page)

Concepts

Integration Services Error and Message Reference

Flat File Connection Manager