Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
In SQL Server Data Tools (SSDT), open the Integration Services package that has the ADO NET destination.
On the Data Flow tab, double-click the ADO NET destination.
In the ADO NET Destination Editor, click Error Output.
Options
Input or Output
View the name of the input.
Column
Not used.
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
Not used.
Description
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
Apply the error handling option to the selected cells.
See Also
ADO NET Destination Editor (Connection Manager Page)
ADO NET Destination Editor (Mappings Page)