Below is my XML Schema definition, which I generated from the XML file I want to import into a table. You will notice an "ErrorMessage" element. This does not display as an available column in the XML Source column mappings. All I am interested in importing into a table are the "ClientRef" and "ErrorMessage" elements. Only the "ClientRef" is visible. Has anyone any ideas how I can get the "ErrorMessage" element to display in the XML Source mappings? Thanks
<?xml version="1.0"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="CompleteJob">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" name="ClientRef" type="xs:string" />
<xs:element minOccurs="0" name="PractCompleteDate" type="xs:dateTime" />
<xs:element minOccurs="0" name="Sor">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" name="ClientRef" type="xs:string" />
<xs:element minOccurs="0" name="SorSequence" type="xs:unsignedByte" />
<xs:element minOccurs="0" name="KeySorNumber" type="xs:string" />
<xs:element minOccurs="0" name="SorQty" type="xs:unsignedByte" />
<xs:element minOccurs="0" name="SorValue" type="xs:decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="ErrorMessage" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>