The following also seems to do the trick (I'm using SQL Server 2008) and is more elegant than the For Loop:

on the properties of the Event Handler (note that I mean the Event Handler itself, not one of the tasks inside the Event Handler), set ForceExecutionResult to Failure and FailPackageOnFailure to True.