The xml code of Appendix A corresponds perfectly with the xsd of Appendix B; however, when I use the bulkload function of SQLXML 3.0 for MS SQL Server 2000, I get the error of Appendix C.

This question is very urgent and there is no clear reason why this is happening. The xml and xsd of Appendix D and Appendix E work just fine. The code used to create the working table and non-working table are in Appendix F and Appendix G, respectfully. Data has already been inserted into both tables successfully using basic sql insert commands.
Any help at all would be appreciated; I would like to have some insight as to why it refers to 'column' as if it is a name of something.

Thank you in advance,
David

Appendix A
---------------------------

<?xml version="1.0" encoding="utf-8"?>
<event>
<netPathCreate>
<eventId>7546</eventId>
<pathId>469</pathId>
<moteAId>2768</moteAId>
<moteBId>1944</moteBId>
</netPathCreate>
</event>

Appendix B
---------------------------

<?xml version="1.0" encoding="UTF-8" ?>
<!-- edited with XMLSPY v2004 rel. 3 U (http://www.xmlspy.com) by Alex Lushin (Mainsail) -->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema" elementFormDefault="qualified" attributeFormDefault="unqualified">

<xsd:element name="event" sql:is-constant="1">

<xsd:complexType>
<xsd:sequence>
<xsd:element name="netPathCreate" sql:relation="NetPathCreate">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="eventId" type="xsdositiveInteger" sql:field="eventid " />
<xsd:element name="pathId" type="xsdositiveInteger" sql:field="pathid" />
<xsd:element name="moteAId" type="xsdositiveInteger" sql:field="moteaid" />
<xsd:element name="moteBId" type="xsdositiveInteger" sql:field="motebid" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>

</xsd:element>

</xsd:schema>


Appendix C
---------------------------

Error: 0x80004005 - Schema mapping
Schema: invalid value for 'column' on 'NetPathCreate'.
Unspecified error

Appendix D
---------------------------

<?xml version="1.0" encoding="utf-8"?>
<event>
<netMoteJoin>
<moteId>26</moteId>
<macAddr>00-00-00-00-00-00-16-42</macAddr>
</netMoteJoin>
</event>

Apendix E
--------------------------

<?xml version="1.0" encoding="UTF-8" ?>
<!-- edited with XMLSPY v2004 rel. 3 U (http://www.xmlspy.com) by Alex Lushin (Mainsail) -->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema" elementFormDefault="qualified" attributeFormDefault="unqualified">

<xsd:element name="event" sql:is-constant="1">

<xsd:complexType>
<xsd:sequence>
<xsd:element name="netMoteJoin" sql:relation="NetMoteJoin">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="moteId" type="xsdositiveInteger" sql:field="moteid" />
<xsd:element name="macAddr" type="xsd:string" sql:field="macaddr" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>

</xsd:element>

</xsd:schema>

Appendix F
----------------------------------

CREATE TABLE NetPathCreate (
eventid bigint,
pathid bigint,
moteaid bigint,
motebid bigint,
PRIMARY KEY(eventid))


Appendix G
----------------------------------

CREATE TABLE NetMoteJoin (
moteid bigint,
macaddr varchar(25),
PRIMARY KEY(moteid))