I have a XML datamodel which I m trying to load in a table.
Goal is to flatten the xml in a table
The XML is SAP Successfactors Succession data model and when I analyze it in Power BI it has multiple sections as shown below in the pic .

In SSIS , first I overcame namespaces by following the article-
http://surendrathotamsbiproffesional.blogspot.com/2014/01/error-unable-to-infer-xsd-from-xml-file.html
but now I m getting XML Adapter Does Not Support Mixed Content on Complex Types.
Below is a section from XML and this pattern i see around 421 places in the XML
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="succession-data-model">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" name="description" type="xs:string" />
<xs:element minOccurs="0" maxOccurs="unbounded" name="standard-element">
<xs:complexType mixed="true">
<xs:sequence minOccurs="0">
<xs:element minOccurs="0" maxOccurs="unbounded" name="label">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="lang" type="xs:string" use="optional" />
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="picklist">
<xs:complexType>
<xs:attribute name="id" type="xs:string" use="optional" />
</xs:complexType>
</xs:element>
How can I overcome this problem of parsing ?What is the recommended way of doing this?
Expected o/p :
Separate tables
1. standard-element table containing only standard-element data
2. userinfo-element table containing only userinfo-element data
3. background -element table containing only background -element data
4. tab-element table containing only tab-element data
5. hris-element table containing only hris-element data
6. hris-action table containing only hris-action data
7. element-permission table containing only element-permission data
8. view-template table containing only view-template data
Input xml: