title: SSIS cannot convert because a potential loss of data
body: <p>I have an SSIS package that imports from an Excel doc to a Database table. I am getting the following errors:</p>
  
  <pre><code>[Excel Source [1]] Error: There was an error with output column "ShipTo" (47) on output
  "Excel Source Output" (9). The column status returned was: "The value could not be 
  converted because of a potential loss of data.".
  
  [Excel Source [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The
  "output column "ShipTo" (47)" failed because error code 0xC0209072 occurred, and the
  error row disposition on "output column "ShipTo" (47)" specifies failure on error. An
  error occurred on the specified object of the specified component.  There may be error
  messages posted before this with more information about the failure.
  
  [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method
  on component "Excel Source" (1) returned error code 0xC0209029.  The component returned
  a failure code when the pipeline engine called PrimeOutput(). The meaning of the
  failure code is defined by the component, but the error is fatal and the pipeline 
  stopped executing.  There may be error messages posted before this with more
  information about the failure.
  </code></pre>
  
  <p>I have done reading and found articles to ensure that my datatypes match, and I have done that.  In the Excel doc, there are 184 rows, and in the column that is listed in these errors (shipto) they all have the same value and that is "All". I ran into this last time I ran it, but it was only 4 rows that had "All" so I just entered those values manually, but that won't be very efficient this time. </p>
  
  <p>On the destination table, the column ShipTo is a Varchar(20) so I don't see the size being a problem being that it is one of three things: 1 digit number, 2 digit number, or the word All.</p>
  
  <p>Does anyone have any additional ideas that I would be able to try? Any help is greatly appreciated. Thanks to anyone that can offer any help.</p>