Geek Answers Handbook

SSIS - continue packet flow even after the internal task in the Loop Contach container fails

In the figure below, why does the Foreach contour container not work despite being processed correctly?

How can I get a loop to continue after processing the failure path?

enter image description here

If this helps to find out what is going on in the package, here is the gist:

We have a requirement that data from Excel files are loaded into the database. The package that we divided each Excel file into composite CSV files (one CSV per sheet) and loads the CSV into the database. it is possible that some of the sheets have problems (missing columns, data type of mismatch, etc.), and such erroneous CSV files are fixed by the crash of the DFT path. Ideally, the package should resume processing the remaining CSVs, as well as the rest of the Excel files, and successfully complete the work.

+6
source share
2 answers

Do you have OnError EventHandlers defined for this data flow task? If so, you can also set the Propagate System variable (type Boolean) for this error handler area to "False" .

Also pass Gracefully passing the task error in the SSIS package

+10
source

Each SSIS component has a property called MaximumErrorCount , which determines the number of errors that this particular component can take before the entire packet fails.

You need to increase this value for each component that you want to continue to failure.

+2
source

More articles:


All Articles