send email if the package fail

Jefferson 426 Reputation points
2023-05-11T03:04:42.3433333+00:00

How to send email notification when the package fail to run?

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

Accepted answer
  1. ZoeHui-MSFT 32,406 Reputation points
    2023-05-11T03:24:31.1366667+00:00

    Hi @Jefferson,

    If you want to trigger your mail task when any error occurs, consider the "Event Handlers".

    This SimpleTask article provides a very good overview of the event handlers https://www.red-gate.com/simple-talk/sql/ssis/ssis-event-handlers-basics/

    You may also refer to: Integration Services (SSIS) Event Handlers

    Regards,

    Zoe Hui


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

    0 comments No comments

0 additional answers

Sort by: Most helpful