Reading Dates From An XML Source Adapter

I am using an "XML Source Adapter" in an SSIS Package to try and load an XML file into a database table. But having trouble with a date field.
The XSD defines the field as:-



<xs:element minOccurs="1" name="DateTime" type="xs: string" />

The XML looks like this:-


<DateTime>12/31/2007 10:12:14.123</DateTime>

And the database table column is defined:-



[DateTime] [datetime] NOT NULL,


So in the Data Flow I have a "Data Conversion Transformation" converting [DT_WSTR] to [DT_DBTIMESTAMP].
However, when I run the package I get:-


Error: 0xC02020C5 at Load XXX File, Data Conversion 1 [13550]: Data conversion failed while converting column "DateTime" (15100) to column "DateTimeDT" (15422). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".


So what how do I fix it?
I don't mind losing some miliseconds of precision, so I have tried configuring the error output of the Data Conversion for this field to "ignore failure" for "Truncation". But that seems to have no effect.


I'd be happy to change the XSD to:



<xs:element minOccurs="1" name="DateTime" type="xs:dateTime" />

But the "XML Data Flow Source" doesn't seem to support the dateTime data type.
Any suggestions appreciated. Thanks.