title: SSIS Error Code and Error Column
body: <p>Importing text files via SSIS. I have few text files were I'm converting Date Columns using derived column transformation.
  I'm redirecting the error rows to a different table.
  I get two columns extra namely "ErrorColumn" "ErrorCode" which provides some value. 
  My question is what does this value specify , how can I know what is wrong with the error rows that were redirected or failed conversion.
  Since this is for reporting I want all the rows to go to the destination table. Any suggestions will be greatly appreciated.</p>
  
  <p>Example :</p>
  
  <pre><code>ErrorCode   ErrorColumn
  -1073442796 4
  -1073442796 10
  -1073442796 10
  -1073442796 10
  -1073442796 10
  -1073442796 10
  </code></pre>