title: Flat file destination columns data types validation
body: <p>A source database field of type INT is read through an OLE DB Source. It is eventually written to a Flat File Destination. The destination Flat File Connection Manager > Advanced page reports it as a <code>four-byte signed integer [DT_I4]</code>.</p>
  
  <p>This data type made me think it indicated binary. Clearly, it does not. I was surprised that it was not the more generic <code>numeric [DT_NUMERIC]</code>.</p>
  
  <p>I changed this type setting to <code>single-byte signed integer [DT_I1]</code>. I expected this to fail, but it did not. The process produced the same result, even though the value of the field was always > 127. Why did this not fail?</p>
  
  <p>Some of the values that are produced are </p>
  
  <pre><code>1679576722
  1588667638
  1588667638
  1497758544
  1306849450
  1215930367
  1215930367
  1023011178
  1932102084 
  </code></pre>
  
  <p>Clearly, outside the range of a <code>single-byte signed integer [DT_I1]</code>.</p>
  
  <p>As a related question, is it possible to output binary data to a flat file? If so, what settings and where should be used?</p>