Send email when job fails and run next task which is in loop - SSIS Package

Jagdeep Singh 1 Reputation point
2022-11-15T13:09:40.573+00:00

Send email when job fails and run next task which is in loop - SSIS Package

We are able to send email when one task failed but it fails whole SSIS package and not run the next job. I want to run the next job in the loop if any job fails and also send email for the failed task.

I have tried with the propagate property , it do run the next task if one fails but it is not sending email of the failed task.

anybody faced this issue

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,310 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,260 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 35,226 Reputation points
    2022-11-16T01:40:24.607+00:00

    Hi @Jagdeep Singh ,

    You may try to use Event Handler in your package.

    Reference here: ssis-event-handlers-basics.

    integration-services-ssis-event-handlers

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


  2. Jingyang Li 5,891 Reputation points
    2022-11-17T15:16:18.223+00:00

    A Constraint has three options: Success, Failure and Completion.
    Try Completion in your case.

    0 comments No comments

  3. Jagdeep Singh 1 Reputation point
    2023-01-06T13:03:19.46+00:00

    Hello @Jingyang Li

    tried the completion in the constraint , it is not moving to the next task when the current task fails. this is not working .

    can you please help me out in this.

    0 comments No comments

  4. Yitzhak Khabinsky 25,731 Reputation points
    2023-01-06T14:16:52.1+00:00