title: SSIS Data Conversion Error despite using Data Conversion and accurate destination Datatype
body: <p>I'm getting the following error when I run my package:</p>
  <blockquote>
  <p>[Data Conversion [2]] Error: Data conversion failed while converting column &quot;FieldName&quot; (373) to column &quot;Copy of FieldName&quot; (110).</p>
  <p>The conversion returned status value 2 and status text &quot;The value could not be converted because of a potential loss of data.&quot;.</p>
  </blockquote>
  <p>However, I don't understand why.  I have double checked the inputs and outputs to validate that they make sense and are what I expect.  I've also checked all the raw data in the column in my excel file.</p>
  <p>My package setup:
  Excel Datasource feeding Data Conversion then Derived Column and finally output to Ole DB Destination (sql)</p>
  <p>What I've done:</p>
  <p>I opened the advanced editor on the data conversion.  I confirmed that the incoming data type is <code>DT_STR</code> which can be expected since the source datatype wasn't correctly identified.  It is actually a date in my excel file.  I confirmed that the data conversion output column is <code>database timestamp [DT_DBTIMESTAMP]</code> as I have set it to be.  My destination table has a DateTime datatype for <code>FieldName</code>.</p>
  <p>What am I missing?</p>