title: Handing SSIS validation failures
body: <p>I'm trying to implement the SSIS package failure handler. I've added onError Event handler on whole package and failure operation the task where i'm expecting an error in the control flow.</p>
  
  <p>The main task of the package is to pick up some data from the db, 
  the error handler is Send Mail Task sending email message with error description.</p>
  
  <p>Now, I'm trying to emulate a common error: I make some changes in the SQL query (for example, set incorrect name for one of the columns) and try to run the package.</p>
  
  <p>What i see is that package fails on validation stage and does not even proceed to execution, saying</p>
  
  <pre><code>Error:  SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occured. Error Code 0x80040E14. An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0"     
  Hresult 0x80040E14 Description "Statement(s) could not be prepared"
  Description "The multipart identifier "MyTable.SomeWrongField" could not be bound". 
  Error: "OLE DB Source" failed validation and returned validation status "VS_BROKEN".
  </code></pre>
  
  <p>It doesn't even procceed to execution, failing right after validation.
  How to set the error handle so it handles EVERY error, even the issue like this (incorrect sql request)? </p>
  
  <p>Thanks.</p>