title: How do I convert the ErrorCode and ErrorColumn in SSIS to the error message and column name?
body: <p>I am redirecting rows from a flat file source to a flat file destination. The default metadata in the redirected rows are:</p>
  
  <ul>
  <li>The original flat file source row</li>
  <li>The ErrorCode</li>
  <li>The ErrorColumn</li>
  </ul>
  
  <p>What I get in the output flat file is the source row (nice) and the error code (not nice, ex. -1071628249) and the error column (not nice since it's the internal ID of the column).</p>
  
  <p>How can I transform the rows to output the error message (e.g. "The data was truncated.") and the column name as defined in the flat file source?</p>
  
  <p>In other words, instead of <code>...,-1071607675,10</code> I'd like to see:</p>
  
  <p><code>...,The data was truncated,Firstname</code></p>
  
  <p>or alternatively (if the previous is not possible);</p>
  
  <p><code>...,DTS_E_FLATFILESOURCEADAPTERSTATIC_TRUNCATED,Firstname</code>.</p>