question

KeshaShah-3519 avatar image
0 Votes"
KeshaShah-3519 asked CarrinWu-MSFT commented

OnError event does not execute

Hello everyone,

I'm facing an issue with my SSIS Package as below:

I've created one package which has dataflow tasks, script tasks, execute SQL tasks, etc. I've set FailParentOnFailure and FailPackageOnFailure properties of all tasks to true and created OnError event on the package level. But when the package fails, OnError event is not capturing the failure and errors are not getting logged.

Can anyone help me out with this?

Any help will be appreciated

sql-server-integration-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KeshaShah-3519, we have not get a reply from you. Did any answers could help you? If there have any answers helped you, please do "Accept Answer". If not, please feel free to let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

Hi @KeshaShah-3519, we have not get a reply from you. Did any answers could help you? If there have any answers helped you, please do "Accept Answer". If not, please feel free to let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
cooldadtx avatar image
0 Votes"
cooldadtx answered

Without a repo code I doubt we will be able to help. We use SSIS everywhere and our OnError logic works fine. But I'm a little concerned over your setting of the failure properties. Not sure why you'd set this on all the tasks. In general each "container" can have an error flow. The error flow is where you put your error handling. For example most people log to some external error log. All your tasks can point to the same error flow (for convenience) or do something different, depending on your needs. Seems like you should be able to put a breakpoint in your error flow task and run it in the designer to verify the error handling is working correctly.

You should also probably consider looking at the output logs for SSIS to see how the package is flowing. This will help indicate whether it is actually calling your error flow task and your task is just not working properly.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @KeshaShah-3519,

Welcome to Microsoft Q&A!

Have you select True for DelayValidation? Please refer to this thread.
121651-true.png
121652-delayvalidation.png

Please refer to Add an event handler to a package to get the detail steps.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



true.png (19.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RyanAbbey-0701 avatar image
0 Votes"
RyanAbbey-0701 answered

Have you got "DisableEventHandlers" set to True? Any expression on your event handler to determine whether it should fire or not?

Otherwise you'll have to provide more detail on your setup, what is erroring, what the logs say etc etc

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.