Excel Destination Editor (Error Output Page)

Use the Advanced page of the Excel Destination Editor dialog box to specify options for error handling.

To learn more about the Excel destination, see Excel Destination.

Options

• Input or Output
  View the name of the data source.

• Column
  View the external (source) columns that you selected in the Connection Manager node of the Excel 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

Tasks

Loop through Excel Files and Tables by Using a Foreach Loop Container

Reference

Excel Destination Editor (Connection Manager Page)

Excel Destination Editor (Mappings Page)

Concepts

Integration Services Error and Message Reference