Hey everyone,
This should be a common question, everyone may asked,
however I cannot find the result. It's about use XML bulkload,
I don't know how to mapping the schema file.

(1)XMLdata need to import
<t name="t-text">
<c1 a="c1-text"/>
<c2>c2-text</c2>
</t>

(2)SQL Server table ready to be inserted
table t (c1, c2)

(3)XML Schema
<xsd:element name="t" sql:relation="t">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="c1" ????>
<xsd:complexType>
<xsd:attribute name="a" type="xsd:string" sql:field="c1"
/>
</xsd:complexType>
</xsd:element>
<xsd:element name ="c2" type="xsd:string" sql:field="c2"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>


???? is blank --- bulkload request a "relation"
???? is "sql:is-constant="true" --- NG
???? is "sql:mapped="false" --- c1 is ignored

what the ???? in schema should be?

thanks!
Sam