How to: Configure an Error Output in a Data Flow Component
Many data flow components support error outputs, and depending on the component, SSIS Designer provides different ways to configure an error output.
To configure an error output
Use the following procedure to configure an error output on any data flow component that supports an error output.
To configure an error output using the Configure Error Output dialog box
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
In SSIS Designer, click the Data Flow tab.
Drag the error output, represented by the red arrow, from the component that is the source of the errors to another component in the data flow.
In the Configure Error Output dialog box, select an action in the Error and Truncation columns for each column in the component input.
To save the updated package, click Save Selected Items on the File menu.
Alternatively, use the following procedure to configure an error output for a component. This procedure does not apply to the DataReader source, the Import Column transformation, the OLE DB Command transformation, or the SQL Server 2005 Compact Edition destination.
To add an error output using a component dialog box
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
In SSIS Designer, click the Data Flow tab.
Double-click the data flow components in which you want to configure an error output and, depending on the component, do one of the following:
- Click Configure Error Output.
- Click Error Output.
Set the Error option for each column.
Set the Truncation option for each column.
Click OK.
To save the updated package, click Save Selected Items on the File menu.
See Also
Tasks
Handling Errors in Data
How to: Configure Error Output Columns
Other Resources
Debugging How-to Topics (SSIS)