title: Error when using data conversion in only one column SSIS
body: <p>I have an XML source that contains a column for [Cellphone] which is basically a 10 digits phone number, im using data conversion to convert this column to varchar(50) to match what I have on the table but i get this error whenever I run the package.</p>
  <blockquote>
  <p>[Data Conversion 1 [136]] Error: Data conversion failed while converting column &quot;CO-CellPhone&quot; (763) to column &quot;Copy of CO-CellPhone&quot; (234).  The conversion returned status value 6 and status text &quot;Conversion failed because the data value overflowed the specified type.&quot;.</p>
  </blockquote>
  <blockquote>
  <p>[Data Conversion 1 [136]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.</p>
  </blockquote>
  <blockquote>
  <p>The &quot;Data Conversion 1.Outputs[Data Conversion Output].Columns[Copy of CO-CellPhone]&quot; failed because error code 0xC0209082 occurred, and the error row disposition on &quot;Data Conversion 1.Outputs[Data Conversion Output].Columns[Copy of CO-CellPhone]&quot; 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.</p>
  </blockquote>
  <p>I tried to change it to integer but it didn't work, I checked the XML source and this is the value</p>
  <pre><code>&lt;CO-CellPhone&gt;4855895687&lt;/CO-CellPhone&gt;
  </code></pre>
  <p>This is dummy data by the way :)
  Thanks in advance</p>