send email if the package fail

Question

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

Answer 1

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.