title: SSIS: Capture Truncation Warning from Flat File Source with "Ignore Failure" Enabled
body: <p>I have a 2005 SQL Server Integration Services (SSIS) package that is loading delimited flat files into some tables. A very small percentage of records have a text field that is <em>longer</em> than the file format specification says it can be.  Rather than try to play an ongoing game of "guess the real maximum length", the customer has requested I just truncate anything over the size in the spec.</p>
  
  <p>I have set the Trunctation event to "Ignore Failure" in the Flat File Source Editor, and that takes care of my extra data.  However, it seems to be a completely silent truncation (it does not write any warning to the log).  I am concerned that if there is ever a question about what data has been truncated, I have no way to identify it.</p>
  
  <p><strong>What is a simple way to log the fact the truncation happened?</strong>  </p>
  
  <p>It would be enough to identify that the file had a truncated row in it, but if I could also specify the actual row that would be great.  Whether it is captured as part of the built in package logging or I have to make a special call makes no difference to me.</p>