A part of your data consolidation process involves extracting data from Excel workbooks. Occasionally, the data contains errors that cannot be corrected automatically. How can you handle this problem

Question

Options

• ARedirect the failed data flow task to an External Process task, open the problematic Excel
• BRedirect the failed data flow task to a File System task that moves the erroneous file to a
• CIf the error cannot be corrected automatically, there is no way for SSIS to continue with the
• DNone of the answers above are correct.

• A
  14% (6)
• B
  75% (33)
• C
  5% (2)
• D
  7% (3)

Explanation

SSIS allows you to configure error outputs on most data flow components to redirect rows that fail processing instead of failing the entire package. When an Excel source row generates an error that cannot be auto-corrected, the erroneous row (or the entire problematic file) can be redirected. Using a File System task, the problematic Excel file can be moved to a designated error or quarantine folder for manual review. This allows the rest of the ETL process to continue running. This is a common SSIS error-handling pattern: isolate bad data, move it aside, and let the package continue processing valid data.

No community discussion yet for this question.