Event handler won''t work

Dear all,

Previously I've posted about precedence error that didn't work and now it works, thanks to John Welch for his support. But when I tried to use event handler, it won't work. When error occured it didn't redirect to the OnError event handler. And then I built another package but with Data Flow task only, put a simple Script task inside OnError event handler and strange..it worked fine. There is no differences between my first Data Flow task and the last Data Flow task, totally the same process. I've captured both execution result. This is the first failure Data Flow task and the last success Data Flow Task (failure and success herein means that OnError work or not)

And then I did some testing in my last package contains a success Data Flow task. I put a new Data Flow task by copy from the previous one, execute it and OnError won't work again. Then I delete it, execute the previous one and OnError worked fine. I really don't understand why by adding a new Data Flow Task then OnError event handler won't work ?

Any help would be appreciate. Thanks in advance.

Best regards,

HeryEvent handlers can fire for each task and component in your package. Make sure that the correct task or component is calling the event handler.|||Hi Danny,

I'm pretty sure with that. There's an update today. My package has many foreach containers inside it and today I tried deleted all containers but one. Strange..when I tested it redirect to OnError event when an error occured. The conclusion is to use an event handler it should be one package and one task, isn't it ? It's make me more confuse. Please help me guys.

Thanks in advance,

Best regards,

Hery|||I've used event handlers in packages with many containers without problems. It really sounds like there might be some corruption in the package, or a setting that is missing.|||Hi John,

What makes the package get corrupted ? And if there were missing settings, how can I find it ? since there's no good explanation even in MSDN.

Best regards,

Hery|||

First you need to narrow down the problem. If you take the package that is failing, and recreate one container at a time in a new package (not copying them), when does it break? Are all the property setting identical in the package that is working?

|||In the new package I didn't recreate the container but Data Flow task and I didn't copied it from the old one. The property setting is identical with the old one.
And I didn't disagree that the failed package is corrupted because event handler worked if I got one container left, like I said before I've deleted all containers but one and the event handler worked fine with the only one container.|||So, is there any chance this problem get solve ?

Best regards,

Hery