Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
notes4we
Yak Posting Veteran
90 Posts |
 Posted - 2008-09-24 : 09:04:19
|
| Friends,I had set a Send Mail Task in SSIS on success for the packages that I have created. I received the success messages on my email when the package successfully executed. But to my surprise, whenI have set a Send Mail Task in SSIS on failure for the packages that I have created; I am not getting the email stating that the package has failed.I would appreciate if anyone of you could let me know the possible reasons for not getting failure emails.Thank you,notes4we |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-09-24 : 10:08:18
|
| Are you using Job agent to execute the package or from BIDS? |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-09-24 : 10:14:22
|
| If from BIDS then use Even Handlers > OnError and add the Send Mail Task here so when package fail then it sends email. |
|
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-09-24 : 15:47:54
|
| Yes. The packages are now sending emails upon failure, so my issue is resolved.Thank you for your replies. |
|
|
|
|
|
|
Send Mail Task Failure Email