SQLXMLBulkLoad Error
-
Dear All,
I am new on using SQLXML Bulk Load object to import XML to SQL server for further checking, for the test i would like to current several tables from XML
- ListRecords - The list of people
- ListRecordsDate - Date information for people in listRecords, which i would like to store both DateType and Date Information into this table
Currently I have XSD definition and XML attached. However the following error when i execute the VBS
As the XML file is provided by another party and we cannot modify anything from it. Appreciated if anyone can advise
In addition, there is a new requirement to include Information to SQL tables, e.g.
<Information>
<Name>XXX</Name>
<Address>1 ABC Building</Address>
<Address>DEF Street</Address>
<Phone>2345679</Phone>
<Phone>4455113</Phone>
</Information>It would be appreciated if anyone can guide me to achieve the goal
-
Have you validated the XML against the XSD?
-
of course, no error.
Appreciated if you can advise how i can modify the XSD for SQLXMLBULK LOAD
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply