SSIS Packages Reports success after Task Failure

Question

This SSIS package is made up of several tasks.

The second task fails (it's a SQL task, a permissions error - now fixed and reason for failure not important!). In the job history I can see that task failing.

The only precedent condition is a success condition on the next task. No further tasks run. The whole job reports success despite this task failure. Why?

(I do have an event in the OnError on the task that fails - which logs to a separate database - and this works.)

Please see image.

Answer 1

Click on that task, and set the FailPackageOnFailure property to True.

By default, this property is false, so you might want to do this on all the other tasks while you're at it.