Package Does Not Stop When Supposed To

Hi,

I have a package with For Loop container.

It looks like this:

FOR LOOP (until @IsCurrent < 1) [
[Execute Package Task 1] --> [Execute Package Task 2] --> [Execute SQL Task] --expression--> [Script Task]
]

So, in the [Execute SQL Task], it runs a stored procedure, which returns a 0 or 1 value, which is bound to the variable @IsCurrent. The variable then gets evaluated in the "expression." If @IsCurrent is 0, execution continues to the [Script Task]. That part works fine.

The problem is occurring in the [Script Task] portion. All the Script Task does is "sleep" for 3 minutes. Here is an excerpt of the code:


Dts.Variables("sleepCounter").Value = CInt(Dts.Variables("sleepCounter").Value) + 1

If CInt(Dts.Variables("sleepCounter").Value) = 20 Then

Dts.TaskResult = Dts.Results.Failure

Exit Sub

End If

So, as you can see, if "sleepCounter" = 20, it fails the task, which should then fail the package, right??

However, the package keeps running, even after sleepCounter has exceeded 20. The MaximumErrorCount on the For Loop container is set to 20 also. So after 20 failures, this package should fail, but it isn't!

Any ideas?

Thanks