Share via

Configure an Error Output in a Data Flow Component

  • Article

Many data flow components support error outputs, and depending on the component, SSIS Designer provides different ways to configure an error output. In addition to configuring an error output, you can also configure the columns of an error output. This includes configuring the ErrorCode and ErrorColumn columns that are added by the component.

Configuring an Error Output

To configure an error output, you have two options:

  • Use the Configure Error Output dialog box. You can use this dialog box to configure an error output on any data flow component that supports an error output.

  • Use the editor dialog box for the component. Some components let you configure error outputs directly from their editor dialog box. However, you cannot configure error outputs from the editor dialog box for the ADO NET source, the Import Column transformation, the OLE DB Command transformation, or the SQL Server Compact destination.

The following procedures describe how to use these dialog boxes to configure error outputs.

To configure an error output using the Configure Error Output dialog box

  1. In SQL Server Data Tools (SSDT), 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. 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.

  5. In the Configure Error Output dialog box, select an action in the Error and Truncation columns for each column in the component input.

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

To add an error output using the editor dialog box for the component

  1. In SQL Server Data Tools (SSDT), 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. 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 steps:

    • Click Configure Error Output.

    • Click Error Output.

  5. Set the Error option for each column.

  6. Set the Truncation option for each column.

  7. Click OK.

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

Configuring Error Output Columns

To configure the error output columns, you have to use the Input and Output Properties tab of the Advanced Editor dialog box.

To configure error output columns

  1. In SQL Server Data Tools (SSDT), 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.

    Note

    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, on the File menu, click Save Selected Items.

See Also

Error Handling in Data