Easy response I am sure....
The following is a snippet of XML that I am developing an Annotated XSD for use with XML Bulk Load into SQL Server 2000.

I can successfully map to 4th level elements i.e. 'root/businessEntity/dgrFund/endorsedFrom' but am unable to map to 5th level elements i.e. 'root/businessEntity/dgrFund/dgrFundName/organisationName'

Ther error I currentl receive using the following files is:
Schema: unable to load schema 'Build_08.01.xsd'. An error occurred (Build_08.01.xsd#/schema[1]/element[position() = 1 and @name = 'businessEntity']/complexType[1]/sequence[1]/element[position() = 2 and @name = 'dgrFund']/complexType[1]/sequence[1]/element[position() = 1 and @name = 'dgrFundName/organisationName']
Error parsing 'dgrFundName/organisationName' as NCName datatype.
A name contained an invalid character.).

Any help much appreciated!!

Sample XML
<root>
<businessEntity>
<mainTradingName>
<organisationName>Any Old Name</organisationName>
<effectiveFrom>2000-06-14</effectiveFrom>
</mainTradingName>
<dgrFund>
<dgrFundName>
<organisationName>Some Name</organisationName>
<isCurrentIndicator>Y</isCurrentIndicator>
</dgrFundName>
<endorsedFrom>2000-07-01</endorsedFrom>
<endorsedTo>0001-01-01</endorsedTo>
</dgrFund>
</businessEntity>
</root>

Snippet of Annotated Schema

<xsd:element name="dgrFund" sql:relation="tblDGR" sql:relationship="PartyDGR">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="dgrFundName/organisationName" type="xsd:string" sql:field="DGROrganisationName"/>
<xsd:element name="endorsedFrom" type="xsd:date" sql:field="endorsedFromDate"/>
<xsd:element name="endorsedTo" type="xsd:date" sql:field="endorsedToDate"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>

You can't name an element 'dgrFundName/organisationName' as the '/' is illegal, just call it 'organisationName'. I'm away from my reference book so can't provide a full working example I'm afraid.

--

Joe