title: How to send an email on ssis package failure?
body: <p>My requirement is I need to send an email with error details if any one of the components used in my package got failed.</p>
  
  <p>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).</p>
  
  <p>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.</p>
  
  <p>Please suggest the best way to do this......</p>