I am using SQLXML parser to insert huge xml files into my database tables.
I am able to insert small files but with big size files(500 MB) i am fiding an error which says "illegal xml character".
I serached online and someone suggested that maybe the xml file has some illegal chars that was causing trouble with the parser...my question is does anyone know how to check if an xml file has illegal chars using xmlspy software and if yes...how do i get rid of them so that i can do a bulk insert using SQLXML.
urgent help please!!