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-11-05 : 08:35:18
|
| I have a send mail task in the control flow. It gives error messages if I just have the errors coming from a single task, for eg. Data Flow Task. But if I have multiple error precedence constraints attached to the single send mail task, then even if there is error I get no errors at all.Is there any way where I can have 2 execute sql tasks, 1 data flow task, etc. all attached to the send mail task on failure.I am not sure if this is possible, but I guess there should be some way to achieve this.Any help would be greatly appreciated.Thank you. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-11-05 : 09:34:16
|
| I don't quite get what you mean but try "Logical OR" on multiple constraints option. |
 |
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-11-05 : 09:50:13
|
| Yes. What you get is right. This is working. I just tried it. It was so simple, but I did not know which property should I change.Thank you. |
|
|
|
|
|
|
Send Mail Task for multiple failures