I have 15-20 data task each in their own sequence container in a single SSIS. Is it possible to catch the data task or sequence which failed and email that details (task name or sequence name, cause for failure) to a user?
+2
A:
Yes, you can create a sequence level OnError handler and do whatever you need to do in there. The error details are available as system variables.
starskythehutch
2010-08-13 13:27:32
A:
WE only have one failure email at the top of the food chain. What we do is catch the task name in it. the System::SourceName variable contains the task that failed.
HLGEM
2010-08-13 21:30:24