How to: Configure Error Output Columns
Many data flow components support error outputs. This procedure describes how to configure columns in the error output, including the ErrorCode and ErrorColumn columns added by the component.
To configure error output columns
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.
Right-click the component whose error output columns you want to configure and click Show Advanced Editor.
Click the Input and Output Properties tab and expand <component name> Error Output and then expand Output Columns.
Click a column and update its properties.
The list of columns includes the columns in the component input, the ErrorCode and ErrorColumn columns added by previous error outputs, and the ErrorCode and ErrorColumn columns added by this component.
To save the updated package, click Save Selected Items on the File menu.