I have an SSIS sequence container that extracts data from individual source database tables into a Stage layer. However, I need to know when a given calculation crashes in order for the given error to be written to the configuration table, which is provided by the yellow highlighted task in which the procedure is called. The problem is that if a given container falls due to an error, it does not flow through failure precendence constraint into the given task (LogPackageFailed).
I tried setting FaiPackageOnFailure together with FailParentOnFailure to TRUE in the properties, but it didn't help. The proposed solution in the following links does not work either:
- http://techblog.elish.net/2010/12/ssis-foreach-loop-container-continue-on.html
- https://simonworth.wordpress.com/2009/11/11/ssis-event-handler-variables-propagate/
, which was addressed in a previous similar query.