SSIS cannot convert text to date
<p>I am trying to convert a text field in an XML file with a value of 2014-04-01T00:00:00-04:00 to a date via a data conversion component.  </p>

<p>The full error message is 
<strong>[Data Conversion [2]] Error: Data conversion failed while converting column "BKG_DATE" (417) to column "Converted_BKG_DATE" (26).  The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".</strong></p>

<p>The conversion is from a DT_WSTR to a database time [DT_DBTIME].</p>

<p>Please note I only need the date value from the xml field value.</p>

<p>Can anyone help me to resolve this. </p>