Hi All,
I am using SQLXMLBulkLoad.SQLXMLBulkload utility
in a VBscript.
I have been getting a error in my error.log
<![CDATA[Illegal xml character.
]]>
The problem is my source XML file ( which i am not supposed to alter) has some junk charachters for which my SAX XML parser is invalidating and throwing error.
I wish to skip all those junk charachters and load the rest of the file into the tables.
Is there any flag that says i could ignore such charachters? or
is there any work around for this?
Please help..!!
Thanks in advance