title: XML Mixed content model with complex types SSIS error
body: <p>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: <code>The XML Source Adapter does not support mixed content model on Complex Types</code>.  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.     </p>
  
  <p><a href="http://www.gpo.gov/fdsys/bulkdata/CFR/2014/title-49/CFR-2014-title49-vol2.xml" rel="nofollow">http://www.gpo.gov/fdsys/bulkdata/CFR/2014/title-49/CFR-2014-title49-vol2.xml</a>
  <a href="http://www.gpo.gov/fdsys/bulkdata/CFR/resources/CFRMergedXML.xsd" rel="nofollow">http://www.gpo.gov/fdsys/bulkdata/CFR/resources/CFRMergedXML.xsd</a></p>