February 12, 2010 at 5:38 am
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>
July 7, 2010 at 3:46 am
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!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy