XML Source Not Displaying all columns in XML file

• Stegzy

  SSC Enthusiast

  Points: 116

  More actions

  February 12, 2010 at 5:38 am

  #138749

  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>

• SID_

  SSC Enthusiast

  Points: 165

  More actions

  July 7, 2010 at 3:46 am

  #1189499

  Hi,

  did you get this sorted?

  I have several cloumns that are not visible under ssis?

  XML notepad show all columns correctly

  I am using ssis xsd generator!