Getting notified when package fails

Astrid o 1 Reputation point
2021-01-29T13:59:39.123+00:00

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.

61933-capture.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,468 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Jim Young 1 Reputation point
    2021-01-29T16:29:04.897+00:00

    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.


  2. Jim Young 1 Reputation point
    2021-01-29T16:59:19.197+00:00

    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.


  3. Jim Young 1 Reputation point
    2021-01-29T21:34:43.437+00:00

    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.

    0 comments No comments

  4. Monalv-MSFT 5,896 Reputation points
    2021-02-01T03:28:35.393+00:00

    Hi @Astrid o ,

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

    62353-cf.png

    62306-showsystemvariables.png

    62344-propagate.png

    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.