Avoid triggering event handler

Question

I have a SSIS package with multiple task and created a on error event handler at package level with mail task. In those task one script task is also there, if the script task is failed, then I don't want to fire event handler. How can we achieve this?

I kept disable event handler property set to True for the script task alone, even though it is triggering event handler.

Answer 1

The only way that i can think of is to trick the package into thinking the script task was successful. Not sure if that's what you want though

Add some error handling to catch the error in the script, log it if required and and convert it to .Success instead of .Failure

Answer 2

Hi @Anudeep Pabbathi ,

Not fully understand your meaning.

Could you please share the tasks in control flow so that we could get details about the issue?

Such like below:

Also you may refer integration-services-ssis-event-handlers for details.

Regards，

Zoe

---

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.
Hot issues October