Export (0) Print
Expand All

How to: Configure Error Output Columns

SQL Server 2005

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.

  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.

Community Additions

© 2015 Microsoft