I am attempting to import an XML file into SQL Server 2000 using the
SQLXML Bulk Load functionality. I have written a DTS Package which
takes an .XML file and .XSD file which I have annotated. I have one
database table I'm using to import the data but I get the following
error:

Schema: relationship expected on 'Task'


Here is a snippet of the .XSD:


<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<!--
************************************************** ****************************
-->
<!-- Parent Tree -->
<xsd:element name="TaskData" type="TaskDataType"
sql:relation="tbl_XML_Data"/>
<!--
************************************************** ****************************
-->
<!-- Define Data Type TaskDataType -->
<xsd:complexType name="TaskDataType">
<xsd:sequence>
<xsd:element name="Task" maxOccurs="unbounded">
<xsd:complexType>
<xsd:complexContent>
<xsd:extension base="TaskType"/>
</xsd:complexContent>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
<!--
************************************************** ****************************
-->
<!-- Define Data Type TaskType -->
<xsd:complexType name="TaskType">
<xsd:sequence>
<xsd:element name="RecordNumber" type="xsdositiveInteger"
sql:field="RecordNumber"/>
<xsd:element name="ContractNumber" sql:field="ContractNumber">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:minLength value="6"/>
<xsd:maxLength value="13"/>
<xsdattern value="[^'&quot;]*"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>