title: SSIS - Continue Package Flow even after inner task in a Foreach Loop Container fails
body: <p>In the figure below, why is the Foreach Loop Container failing <em>despite</em> the fail path (of the DFT that failed) being handled correctly? </p>
  
  <p><strong>How can I get the loop to continue after handling fail path?</strong></p>
  
  <p><img src="https://i.stack.imgur.com/xdi7V.png" alt="enter image description here"></p>
  
  <p>If it helps to know what's going on in the package, here's the gist:
  <BR></p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>