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

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.

  2. In Solution Explorer, double-click the package to open it.

  3. In SSIS Designer, click the Data Flow tab.

  4. Right-click the component whose error output columns you want to configure and click Show Advanced Editor.

  5. Click the Input and Output Properties tab and expand <component name> Error Output and then expand Output Columns.

  6. 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.

  7. Click OK.

  8. To save the updated package, click Save Selected Items on the File menu.

See Also


Handling Errors in Data
How to: Configure an Error Output in a Data Flow Component

Other Resources

Debugging How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance