send email if the package fail

Jefferson 261 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,090 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 22,216 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

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest