Import Complex XML File Into Sql Server 2000

I need help importing a complex xml file using the XML Bulk Load component. I need there to be 2 tables as shown below. I just

cannot seem to figure out how to get this to work with such a complex XML structure. I have shown below my table structure, a

sample of one of the entries of the XML files and what I have so far for my XSD schema. Any help would be great!!!

My Tables:
CREATE TABLE [dbo].[WPXML] (
    [Part] [varchar] (100) PRIMARY KEY,
    [BaseVehicle] [int]  NULL ,
    [Qty] [int]  NULL ,
    [PartType] [int]  NULL ,
    [EngineBase] [int]  NULL ,
    [EngineDesignation] [int]  NULL ,
    [ImageURL] [varchar] (100) NULL ,
    [ThumbURL] [varchar] (100) NULL
)
GO
CREATE TABLE [dbo].[WPPRODUCT] (
    [Part] [varchar] (100) PRIMARY KEY ,
    [PartNumber] [varchar] (100) NULL ,
    [BrandID] [varchar] (4) NULL ,
    [BrandDescription] [varchar] (100)  NULL ,
    [Price] [varchar] (10) COLLATE  NULL ,
    [ListPrice] [varchar] (10) COLLATE  NULL,
    [Weight] [varchar] (10) COLLATE  NULL,
    [Popularity] [varchar] (10)  NULL,
    [OEFlag] [varchar] (10) NULL,
    [ProductRemark] [varchar] (1000) NULL,
    [Note] [varchar] (5000)  NULL 
)
GO

Sample of XML:
<App action="A" id="1484266">
   <BaseVehicle id= "5899"/>
   <EngineBase id= "555"/>
   <EngineDesignation id= "138"/>
   <Qty>0</Qty>
   <PartType id= "6192"/>
   <Part>W0133-1621038</Part>
   <Product>
    <PartNumber>W0133-1621038</PartNumber>
    <BrandID>FUL</BrandID>
    <BrandDescription><![CDATA[Full]]></BrandDescription>
    <Price>17.38</Price>
    <ListPrice>36.60</ListPrice>
    <Available>Y</Available>
    <Weight>1.05</Weight>
    <Popularity>B</Popularity>
   </Product>
   <Product>
    <PartNumber>W0133-1611982</PartNumber>
    <BrandID>KN</BrandID>
    <BrandDescription><![CDATA[K&N Filters]]></BrandDescription>
    <Price>68.78</Price>
    <ListPrice>105.81</ListPrice>
    <Available>Y</Available>
    <Weight>1.80</Weight>
    <Popularity>E</Popularity>
   </Product>
   <Product>
    <PartNumber>W0133-1626304</PartNumber>
    <BrandID>ND</BrandID>
    <BrandDescription><![CDATA[Denso]]></BrandDescription>
    <Price>22.34</Price>
    <ListPrice>36.60</ListPrice>
    <Available>Y</Available>
    <OEFlag>OEM</OEFlag>
    <Weight>1.05</Weight>
    <notes>Notes For This Part</notes>
    <Popularity>D</Popularity>
   </Product>
    <ImageURL><![CDATA[http://img.eautopartscatalog.com/live/W01331621038OES.JPG]]></ImageURL>
   <ThumbURL><![CDATA[http://img.eautopartscatalog.com/live/thumb/W01331621038OES.JPG]]></ThumbURL>
  </App>

My XSD Schema Thus Far:
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xsd:annotation>
  <xsd:appinfo>
    <sql:relationship name="test"
        parent="WPXML"
        parent-key="Part"
        child="WPPRODUCT"
        child-key="Part" />
  </xsd:appinfo>
</xsd:annotation>
  <xsd:element name="App" sql:relation="WPXML" sql:relationship="test">
   <xsd:complexType>
     <xsd:sequence>
           
     <xsd:element name="Qty" type="xsd:integer" />
     <xsd:element name="Part" type="xsd:string" />
 <xsd:element name="BaseVehicle"> 
   <xsd:complexType>
    <xsd:attribute name="BaseVehicle" type="xsd:integer" sql:field="BaseVehicle" /> 
 </xsd:complexType>
    </xsd:element>
    <xsd:element name="PartType"> 
   <xsd:complexType>
    <xsd:attribute name="id" type="xsd:integer" sql:field="PartType" />
   </xsd:complexType>
    </xsd:element>
    <xsd:element name="EngineBase"> 
   <xsd:complexType>
    <xsd:attribute name="id" type="xsd:integer" sql:field="EngineBase" />
   </xsd:complexType>
    </xsd:element>
    <xsd:element name="EngineDesignation"> 
   <xsd:complexType>
    <xsd:attribute name="id" type="xsd:integer" sql:field="EngineDesignation" />
   </xsd:complexType>
    </xsd:element>
 <xsd:element name="ImageURL" type="xsd:string" />
 <xsd:element name="ThumbURL" type="xsd:string" />
 <xsd:element name="Product" sql:relation="WPPRODUCT" sql:key-fields="Part" sql:relationship="test">       
          <xsd:complexType> 
            <xsd:sequence>
              <xsd:element name="Part" type="xsd:string" />
              <xsd:element name="PartNumber" type="xsd:string" >
              </xsd:element>
              <xsd:element name="BrandID" type="xsd:string" >
              </xsd:element>
  <xsd:element name="BrandDescription" type="xsd:string" >
              </xsd:element>
      <xsd:element name="Price" type="xsd:string" >
             </xsd:element>
             <xsd:element name="ListPrice" type="xsd:string" >
             </xsd:element>
             <xsd:element name="Weight" type="xsd:string" >
             </xsd:element>
             <xsd:element name="Popularity" type="xsd:string" >
             </xsd:element>
      <xsd:element name="OEFlag" type="xsd:string" >
             </xsd:element>
      <xsd:element name="ProductRemark" type="xsd:string" >
             </xsd:element>
      <xsd:element name="Note" type="xsd:string" >
             </xsd:element>
            </xsd:sequence>
           </xsd:complexType>
          </xsd:element>
         </xsd:sequence>
     </xsd:complexType>
  </xsd:element>
</xsd:schema>