title: SSIS - the value cannot be converted because of a potential loss of data
body: <p>I am relatively new to SSIS.  I am trying to extract information from an Oracle database using Microsoft OLEDB for Oracle and I am using this query:</p>
  
  <pre><code>SELECT ID FROM Test
  </code></pre>
  
  <p>I get an error message saying: <code>the value cannot be converted because of a potential loss of data</code>.  If I change the query to the following then it works:</p>
  
  <pre><code>SELECT '1' FROM Test
  </code></pre>
  
  <p>I think it is failing because the ID is not an integer.  However, the flat file connection manager shows that the OutputColumnWidth is 50.  What am I doing wrong?</p>
  
  <p><strong>Update 16:30 GMT</strong><br>
  I have looked into this a little more and it appears to be the columns that have a Histogram of 'frequency' or 'none' that are causing the problems.  Those with a Histogram of 'Height Balanced' appear to be OK.</p>