Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ADO NET Destination Editor (Error Output Page)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Use the Error Output page of the ADO NET Destination Editor dialog box to specify error handling options.

To learn more about the ADO NET destination, see ADO NET Destination.

To open the Error Output page

  1. In SQL Server Data Tools (SSDT), open the Integration Services package that has the ADO NET destination.

  2. On the Data Flow tab, double-click the ADO NET destination.

  3. In the ADO NET Destination Editor, click Error Output.

Input or Output

View the name of the input.


Not used.


Specify what should happen when an error occurs: ignore the failure, redirect the row, or fail the component.

Related Topics: Error Handling in Data


Not used.


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 the error handling option to the selected cells.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft