SSIS - Continue Package Flow even after inner task in a Foreach Loop Container fails

Question

In the figure below, why is the Foreach Loop Container failing despite the fail path (of the DFT that failed) being handled correctly?

How can I get the loop to continue after handling fail path?

If it helps to know what's going on in the package, here's the gist:

We have a requirement where data from Excel files must be loaded into a DB. The package we have splits each Excel file into constituent CSV files (one CSV per sheet), and loads the CSVs into the DB. It is possible that some of the sheets have issues (missing columns, data type mismatch etc), and such erroneous CSVs are captured by the fail path of the DFT. Ideally the package must resume processing the rest of the CSVs, and the rest of the Excel files, and exit successfully.

Answer 1

Do you have any OnError EventHandlers defined for that Data Flow Task? If yes, you could as well set the System Variable, Propogate (type Boolean), for that Error Handler scope to 'False'.

Also please go through Gracefully Handing Task Error in SSIS Package