Getting notified when package fails

Question

Hi,

I have a solution that has a large number of packages.

The solution is designed in a way that calls 5 packages dynamically.

If once of the packages fails, the other 4 pipelines keep working.

I would like to know how can even the solution failed, one of the packages failed. I don't want the whole solution to fail.

Answer 1

We need some more information about how you are executing these individual packages.

When you say they are executed dynamically, what exactly does that mean?
Is there a central package that is executing child packages?

If you have a main package that is executing the others you can define an error path that executes a task to send an email, notifying of the failure.

Answer 2

Every executable in SSIS has an error path indicated by the color red. Click on one of the sequence containers that executes a package and you will see a red line. Extend that out to a task that sends an email or other notification task.

Answer 3

A clarification - Every task can have multiple workflow destination. To create an error destination, click on the task, in this case the Execute Package Task, select the green arrow and connect it to the task you want to execute if there is an error. Double click on the workflow and change Value to Error. The task at the end of the workflow route will now only execute if the source task failed.

Answer 4

Hi @Astrid o ,

Please set Propagate variable as False in the Event Handlers on error event.

Please refer to Continue a Foreach loop after an error in a SQL Server Integration Services package.

Best Regards,
Mona

----------

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.