MS SQL XML - xmlbulkload and namespace problem

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

xmlbulkload and namespace problem

heavenlyarts

2006-11-16, 7:15 pm

I'm an xml thickie and after searching for hours I can't find the answer to a
problem.

I have a XML filefragment to load that looks like :-

<L:Record>
<L:Field>fdgdfgfg</L:Field>
</L:Record>

I cannot get it to load thru xmlbulk load. If I modify it to use the default
namespace

<RECORD>
<Field>fdgdfgfg<Field>
<RECORD>

then it loads with this schema

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">

<xsd:element name="RECORD" sql:relation="RECORD" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Field" type="xsd:string" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>

Can anyone show me what I need to do to get the first, non default namespace
fragment to load.

thanx

Jeremy Ramsbottom

Sponsored Links