Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vishu_av
Yak Posting Veteran
69 Posts |
 Posted - 2009-01-09 : 00:22:04
|
| Hi All,I am using SQLXMLBulkLoad.SQLXMLBulkload utilityin a VBscript. I have been getting a error in my error.log<?xml version="1.0"?><Result State="FAILED"><Error><HResult>0xC00CEE2B</HResult><Description><![CDATA[Illegal xml character.]]></Description><Source>XML SAX Parser</Source><Type>FATAL</Type></Error></Result>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? oris there any work around for this?Please help..!! Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-09 : 11:41:46
|
| try bring data with CDATA tags |
 |
|
|
vishu_av
Yak Posting Veteran
69 Posts |
Posted - 2009-01-12 : 00:33:38
|
| Hi,Could you please eloborate on this?Bring data with CDATA tags from xml?Thanks,vish |
|
|
|
|
|
|
sqlxml parsing error