I have a xml file where the root element has xmlns attribute. When I try and
import it using a xsd file and sqlxml bulk insert it does not insert any
records. When I remove the xmlns attribute it works perfectly. How can I
make it work with this attribute, or is there an easy way to automate the
removal of it?

Thanks,

Jeff Langston
Cashless Systems

Have you tried declaring the namespace in the XSD file? If you map the
root element with the namespace in the XSD file it should work.

I am not sure how to do that. Could you post an example?

Thank You!!!

Jeff Langston
Cashless Systems


Show quoteHide quote

Did you see my reply to your other post? It looks like you had declared
it but that your xsd might have been invalid. Take a look at that and
then let me know if it fixes it for you.

Capture FOR XML output in a local string variable?
SQLXMLBulkLoad with VB .Net - No errors but data is not loading
generating XML to validated against the schema
XML files with bad characters
xsd annotations for xpath query