SSIS package fails if any task fails despite forced execution result

Question

I have a package which needs to try a SQL update 3 times. However, even if it succeeds on any iteration, the package will still fail. I've created an abstract package:

]1

with the following settings (some of these may be unnecessary but I've been trying to solve the problem):

• For Loop Container - MaximumErrorCount = 0, ForceExecutionResult = Success
• Sequence Container - MaximumErrorCount = 0, ForceExecutionResult = Success
• Package - MaximumErrorCount = 1, ForceExecutionResult = None

In the real package, there a several other tasks which need to fail the package so I can't set the package's MaximumErrorCount = 0.

So, what I want is:

• Run the "Execute SQL Task"
• On failure, go to the "TF Timer Task" -- working fine
• On success, go to the "Expression Task" which will set a success flag used elsewhere -- working fine
• If the "Execute SQL Task" fails on any iteration, don't fail the package! -- this is the problem; it always fails the package even though it doesn't fail the "For Loop Container"

Thanks.

Answer 1

Sorted it using the instructions at https://www.timmitchell.net/post/2013/08/05/continue-package-execution-after-error-in-ssis/

Basically - Set the OnError::Propogate variable of the "Execute SQL Task" event handler to False. Nothing else was needed.