How to send an email on ssis package failure?
My requirement is I need to send an email with error details if any one of
the components used in my package got failed.
Tried googling and read regarding precedence constraints and event
handlers in ssis but my package is large and is having many
components(control flow items).
Can we define many event handlers for each executables used in package?if
so, I thnk defining event handler for each component is not a good
performance i think.
Please suggest the best way to do this......
No comments:
Post a Comment