Hello everyone,
I use the management of mails on success and in case of failure in the execution of my packages via SQL Server agents
- Packages under Visual studio SSDT 2017 version 15.9.14
- deployment in Mangement studio v18.4 / SqlServer 2014
- Feeding an Azure database
The package is quite simple (in screenshot an example):

This package works perfectly if I run it from Visual Studio, I receive an email in the event of success and in the event of failure.
On the other hand, once deployed in my ETL, only success generates an email. If my task fails, I cannot find the trace of sending an email from the detailed report.
I have the impression that in the event of a crash in one of the tasks in my package, the agent quits the task (to go to the next step) without going to the end of all the tasks in the package (so the sending the mail, which Visual Studio does).
I tried to skip sending emails from the "event manager" tab (OnError / OnTaskFail): same result.
I have been looking for the solution on the web for several hours, but without result.
Do you have a solution to my problem?
(eventually I would like to delete the sending of the "success" mail and keep only the "failure" mail / for the moment I am obliged to do this by elimination, ie count the number of successful packages to deduce those in failure).
Thanking you in advance for your help.
Regards.