xmlbulkload and namespace problem

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

.

Relevant Pages

  • Re: xmlbulkload and namespace problem
    ... Does your mapping schema have a targetNamespace property set? ... I have a XML filefragment to load that looks like:- ... I cannot get it to load thru xmlbulk load. ...
    (microsoft.public.sqlserver.xml)
  • Multiple Type Definition Causes Resource Failure
    ... why a particular form was failing to load and instead generating an error ... about a lack of available resources for that locale. ... to the project option dialog namespace. ... Public Enum MyEnum ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to load an Assembly dynamically?
    ... This is the code I use to load a form from a assembly/ ... 'the sr alias is used to import the System.Reflection namespace ... Dim dll As Reflection.Assembly ...
    (microsoft.public.dotnet.general)
  • SQL 2005 AND SQLXMLBulkLoad
    ... I'm using 2005 and SQLXMLBulkLoad to load some rather large gml files. ... references to the 'gml:' namespace I get no error and no records. ... osgb http://www.ordnancesurvey.co.uk/xml/schema/v5/OSDNFFeatures.xsd ' ... Sample XML that does NOT work (but this is how I would like to load ...
    (microsoft.public.sqlserver.xml)
  • Re: namespace question
    ... ln: from test import myClass ... does it still load a,b,c and numpy into the namespace? ...
    (comp.lang.python)
Loading