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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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.
A Constraint has three options: Success, Failure and Completion.
Try Completion in your case.
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.
Hi @Jagdeep Singh ,
You can try approach outlined here: continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package