title: Why won't my failure flow initiate when SSIS sequence container fails?
body: <p>I have some SSIS sequence containers, and if any of the tasks in them fail I want to direct the flow to a SQL task that cleans everything up so I can address the issue and run it again without having duplicate data.  My problem is that I can't get the flow directed into the SQL task even when something in one of the sequence containers fails.  Seems like this should be the default behavior, but there must be some setting I'm mising.  I played with setting FailParentOnFailure, but all this does is stops the rest of the package from running.  I would insert an image to help with understanding what I have set up, but guess my reputation isn't good enough yet.  :P</p>