I am getting the error:
Invalid character value for cast specification
In my xml file the date is like this:
2004-09-28T00:00:00.0000000-04:00
Because of the field eventdate which is dt:datetime in my
xsd file.
******* MY XSD file
<?xml version="1.0" ?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"
xmlns:sql="urn:schemas-microsoft-com:xml-sql" >
<ElementType name="eventdate" dt:type="DateTime"/>
<ElementType name="ReferenceNO" dt:type="varchar(50)" />
<ElementType name="EventDesciption" dt:type="ntext(16)" />
<ElementType name="ModuleName" dt:type="char(20)" />
<ElementType name="ModuleID" dt:type="char(20)" />
<ElementType name="created_by" dt:type="char(20)" />
<ElementType name="ROOT" sql:is-constant="1">
<element type="Table" />
</ElementType>
<ElementType name="Table" sql:relation="Tab_ccsnetevents">
<element type="eventdate" sql:field="eventdate" />
<element type="ReferenceNO" sql:field="ReferenceNO" />
<element type="EventDesciption"
sql:field="EventDesciption" />
<element type="ModuleName" sql:field="ModuleName" />
<element type="ModuleID" sql:field="ModuleID" />
<element type="created_by" sql:field="created_by" />
</ElementType>
</Schema>
*****
Thank you very much.