Trouble using sql:relation/sql:relationship in xsd file ...


Hi ...

I am attempting to use the sql:relation annotation and am having some troubles. I have used it successfull with the MS Sample (Customer / Order) where all the data is contained in elements (example below).

Code:
<ROOT>
  <Customers>
    <CustomerID>1111</CustomerID>
    <SynchID>700</SynchID>
    <CompanyName>Sean Chai</CompanyName>
    <City>NY</City>
    <Order OrderID="1" />
    <Order OrderID="2" />
  </Customers>
</ROOT>

In the xml that I am having trouble with the data is contained in attributes.  In the code below I get the following 
error when executing the bulk insert. 

Any comments ? 
Thanks !! 
Chris 



//////////////////////////////////////////////////////////////////////////
// error message 
<?xml version="1.0"?><Result State="FAILED"><Error><HResult>0x80004005</HResult><Description><![CDATA[Schema: the parent/child table of the relationship on 'surface' does not match.]]></Description><Source>Schema mapping</Source><Type>FATAL</Type></Error></Result>


//////////////////////////////////////////////////////////////////////////
// xsd file 
<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="MacgowanTest_Atmospheric_Surface"
            parent="MacgowanTestRWISRawAtmospheric"
            parent-key="SystemId RpuId"
            child="MacgowanTestRWISRawSurface"
            child-key="SystemId RpuId" />
    </xsd:appinfo>
  </xsd:annotation>
            
  <xsd:element name="site" sql:relation="MacgowanTestRWISRawAtmospheric" >
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element name="sensors" sql:relation="MacgowanTestRWISRawSurface" 
                                    sql:relationship="MacgowanTest_Atmospheric_Surface">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="surface" sql:relation="MacgowanTestRWISRawSurface"
                                          sql:relationship="MacgowanTest_Atmospheric_Surface" >
                <xsd:complexType>
                  <xsd:attribute name="id" type="xsd:string" sql:field="SensorId"/>
                  <xsd:attribute name="datetime" type="xsd:date" sql:field="ObsDateTime" />
                  <xsd:attribute name="surfacecondition" type="xsd:string" sql:field="SurfaceCondition"/>
                  <xsd:attribute name="surfacetemp" type="xsd:string" sql:field="SurfaceTemperature"/>
                </xsd:complexType>
              </xsd:element>
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:sequence>
    
      <xsd:attribute name="sysid" type="xsd:string" sql:field="SystemId"/>
      <xsd:attribute name="rpuid" type="xsd:string" sql:field="RpuId"/>
    </xsd:complexType>
  </xsd:element>
</xsd:schema>



//////////////////////////////////////////////////////////////////////////
// xml data file 
<?xml version="1.0"?>
<odot_rwis_site_info>
  <site id="200000" number="1" sysid="200" rpuid="0" name="1-SR127 @ SR249" longitude="-84.554946" latitude="41.383527">
    <atmospheric datetime="12/05/2005 03:48:00 PM" airtemp="-490" dewpoint="-800" relativehumidity="73" windspeedavg="11" windspeedgust="19" winddirectionavg="265" winddirectiongust="295" pressure="65535" precipitationintensity="None" precipitationtype="None" precipitationrate="0" precipitationaccumulation="-1" visibility="2000" />
    <sensors>
      <surface id="0" datetime="12/05/2005 03:48:00 PM" name="North Bound Driving Lane" surfacecondition="Dry" surfacetemp="1900" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="450" waterlevel="0">
        <traffic datetime="12/05/2005 03:48:00 PM" occupancy="0" avgspeed="82" volume="21" sftemp="1900" sfstate="255">
          <normalbins>
            <bin datetime="12/05/2005 03:48:00 PM" binnumber="0" bincount="7" />
            <bin datetime="12/05/2005 03:48:00 PM" binnumber="1" bincount="0" />
          </normalbins>
          <longbins>
            <bin datetime="12/05/2005 03:48:00 PM" binnumber="2" bincount="0" />
            <bin datetime="12/05/2005 03:48:00 PM" binnumber="3" bincount="0" />
            <bin datetime="12/05/2005 03:48:00 PM" binnumber="4" bincount="1" />
            <bin datetime="12/05/2005 03:48:00 PM" binnumber="5" bincount="0" />
          </longbins>
        </traffic>
      </surface>
      <surface id="1" datetime="12/05/2005 03:48:00 PM" name="Bridge Deck Simulator" surfacecondition="Other" surfacetemp="-60" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="-999999" waterlevel="0" />
    </sensors>
  </site>
  <site id="200001" number="2" sysid="200" rpuid="1" name="2-Hardin County Garage" longitude="-83.6148588" latitude="40.6305358">
    <atmospheric datetime="12/05/2005 03:49:00 PM" airtemp="-590" dewpoint="-900" relativehumidity="75" windspeedavg="9" windspeedgust="22" winddirectionavg="303" winddirectiongust="299" pressure="65535" precipitationintensity="None" precipitationtype="None" precipitationrate="0" precipitationaccumulation="-1" visibility="2000" />
    <sensors>
      <surface id="0" datetime="12/05/2005 03:49:00 PM" name="Bridge Deck Simulator" surfacecondition="Other" surfacetemp="-410" freezingtemp="32767" chemicalfactor="255" chemicalpercent="255" depth="32767" icepercent="255" subsurfacetemp="300" waterlevel="0" />
    </sensors>
  </site>
  </odot_rwis_site_info>