This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 82%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Jagdeep Singh ,
You can try approach outlined here: continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package
Thank yo for the quick response.
I have tried with the logic mentioned in the link, it is running the next task but it didnt failed any task and not sending any email for the task which is failed.
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
A Constraint has three options: Success, Failure and Completion.
Try Completion in your case.
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.
yes, we are using the same even handler functionality , but when it fails it sends email and it stops there . Requirement is it will run next task even it fails