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.