I want my SSIS package to stop completely after handling the first error.
I have tasks that run in the Package OnError event handler, but then I want the package to exit. Unfortunately, I have not been able to get this to happen.
Even worse, when I get a warning, since I don't have an OnWarning handler, it propagates up to OnError, which is what I want -- but that doesn't seem to count for the MaximumErrorCount, so the OnError tasks run again because PreExecute failed.
FYI, I've tried lots of permutations of the various properties of tasks/SequenceContainers/Package (FailParentOnFailure, FailPackageOnError, ForceExecutionResult, ForcedExecutionValue) and Variables (Propagate) -- with no luck.
Is this just something that can't be controlled?
(I'd also like to avoid a solution that requires ActiveX Script Task or Script Task.)
Thanks...