Export (0) Print
Expand All

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.

Use the following procedure to configure an error output on any data flow component that supports an error output.

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

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft