I have an XML file for a government document and a XSD file that it references. I'm trying to extract information from the XML (chemical name, UN, and hazard classification) and store it into a table in SQL Server 2014. However, whenever I perform an ETL with an XML source, using SSIS, I get the error: The XML Source Adapter does not support mixed content model on Complex Types. How can I work around this? Some ideas I thought about and tried to understand better were: using an XSLT transform on the XML to only retain the pertinent information or use C# and XPath to select only the nodes I want. But this has turned into something a bit harder than I originally thought. Any help or direction is appreciated.
http://www.gpo.gov/fdsys/bulkdata/CFR/2014/title-49/CFR-2014-title49-vol2.xml
http://www.gpo.gov/fdsys/bulkdata/CFR/resources/CFRMergedXML.xsd
0 comments:
Post a Comment