Catching Events

Hi,

I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work...

Another issue, if i omit an error on a transformation object ( in order let the flow continue executing), can this error be managed by an event or record it in a log?

Thanks

Albertoim wrote:

Hi,

I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work...

Thanks

How do you know it doesn't work?

|||

Because the flow i have added to execute when the error event happens does not execute.

|||I have added the event handler at the top level ( Package) for errors events and information events indeed and, as i said before, the flow to execute in this events does not execute. May i have to set some propertie to enable event catching?|||

Hi,

I have done several tests in a new blank project and error events work properly. I have notice that, in th project where i cant catch events, the txt log file is allways blank, so , i supose its something worng with the events, that for any reason arent raised.

In project properties, "DisableEventHandlers" is set to False.

Can anyone help me? Thanks.

|||

Are the errors immediate or near immediate? This scenario of "package level event level handler not firing and empty package logger file" sounds as if you're receiving errors on package load or on package level validation, very early in the attempted load/validate/execute execution sequence.

If particular, what kind of error events are being you receiving? Please attempt to run the package via dtexec (32 or 64 as appropriate) as well and then post the text of the first few errors.

|||The

package works fine... these errors are things like insert a row with a duplicate PK etc... i know that these kind of errors exists because the source table has dirty data. I would like to handle these errors catching an event.

The problem is that no event is raised when i open the log file is completely blank.... i think these two things can be related.