SQLXMLBulkLoad: SAR Parser error while importing huge xml file into database

  • Thread starter Thread starter SevenWow
  • Start date Start date
S

SevenWow

Guest
Using XML Bulk Load 4.0, BTW, my desktop application is 32 bit. The xml data file is big or say huge, 4G or even larger. And calling toISQLXMLBulkLoad.Execute(...) will fail with error like below.

<?xml version="1.0"?><Result State="FAILED"><Error><HResult>0xC00CEE26</HResult><Description><![CDATA[An attribute value must not contain '<'.
]]></Description><Source>XML SAX Parser</Source><Type>FATAL</Type></Error></Result>

Or

<?xml version="1.0"?><Result State="FAILED"><Error><HResult>0xC00CEE25</HResult><Description><![CDATA[Equal expected.]]></Description><Source>XML SAX Parser</Source><Type>FATAL</Type></Error></Result>

It looks like there is a truncation happened while SQLXMLBulkLoad parsing the file. But MSDN document implies this COM component can handle large files, I don't see why this kind of error is happening.

Any help will be highly appreciated.

Continue reading...
 
Back
Top