you need to modify your xsd schema accordingly to make Test complexType and add element City inside it
something like
<xs:element name="Test">
<xs:complexType>
<xs:sequence>
<xs:element name="City" type="xs:string" minOccurs="0" maxOccurs="unbounded" />
....
</xs:sequence>
</xs:complexType>
</xs:element>
the minOccurs part is required if its optional and maxOccurs is required if it can repeat'
similarly add sections for other elements inside
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Bulk load with multiple element types.
Posted - 02/13/2013 : 06:48:32
