| WWalden 2004-02-08, 8:37 am |
| I have a Map that uses functoids to perform lookups on my
SQL database. Some of the values being returned are
SQL 'dateTime' values. The elements they map to in the
document specification are of XML type: 'dateTime'.
The problem seems to be that the XML 'dateTime' doesn't
accept items formatted in SQL 'dateTime'.
The XML seems to want this format: 'yyyy-mm-ddT00:00:00'
But the Database Functoids return the SQL data in this
format: mm/dd/yyyy hh:mm:ss AMPM'
Heres the actual error:
"The XML document has failed validation for the following
reason:
Error parsing '11/1/2012 12:00:00 PM' as dateTime datatype"
I don't get it. How can I ensure that my SQL dates get
into the destination document?
(The added kick in the butt is that testing an XML
instance in the BizTalk Mapper says there is no problem,
and it shows my data where it should be. Only when the
document is submitted to the Channel does it puke it out
with validation errors)
|