title: XmlReaderParsingException: The start element with name <...> and namespace "http..." was unexpected
body: <p>This is for BizTalk 2010.  I am running into a very strange issue that I've not been able to find a solution either using my favorite search engine's results or elsewhere.  </p>
  
  <p>I added several SQL Server 2008 table schemas to BizTalk.  Set up orchestration and mapping without any problems.  BizTalk was able to use WCF_Custom SQL Adapter using XML/BTSAction to insert data to the SQL tables identified in the XML.</p>
  
  <p>Some of those tables had data inserted just fine, except two.  Both had the same error.  The error was pulling from a third table's namespace.  Here's the error in full -- notice that the namespace, ns, is for ns46:professionalAddendum as is expected, but somehow, somewhere, BizTalk is pulling a different namespace, ns35, from a different table:</p>
  
  <p>Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The start element with name "ClaimFilingIndicatorCode" and namespace "<a href="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/professionalCOBAdjustmentsAncillary" rel="nofollow">http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/professionalCOBAdjustmentsAncillary</a>" was unexpected. Please ensure that your input XML conforms to the schema for the operation.</p>
  
  <pre><code>&lt;ns2:Insert xmlns:ns2="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/professionalAddendum"&gt;
    &lt;ns2:Rows&gt;
      &lt;ns46:professionalAddendum xmlns:ns46="http://schemas.microsoft.com/Sql/2008/05/Types/Tables/dbo"&gt;
        &lt;ns46:uid_claim&gt;1b8f20e9-0517-4f00-9ee2-99d5f04d1573&lt;/ns46:uid_claim&gt;
  ERROR&gt;&gt;&gt;&gt;&gt;   &lt;ns35:ClaimFilingIndicatorCode xmlns:ns35="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/professionalCOBAdjustmentsAncillary"&gt;17&lt;/ns35:ClaimFilingIndicatorCode&gt;
        &lt;ns46:ClaimFrequencyTypeCode&gt;1&lt;/ns46:ClaimFrequencyTypeCode&gt;
        &lt;ns46:ProviderAcceptAssignmentCode&gt;B&lt;/ns46:ProviderAcceptAssignmentCode&gt;
        &lt;ns46:BenefitsAssignmentCertificationIndicator&gt;Y&lt;/ns46:BenefitsAssignmentCertificationIndicator&gt;
        &lt;ns46:ReleaseofCode&gt;Y&lt;/ns46:ReleaseofCode&gt;
        &lt;ns46:ProviderOrSupplierSignatureIndicator&gt;N&lt;/ns46:ProviderOrSupplierSignatureIndicator&gt;
      &lt;/ns46:professionalAddendum&gt;
    &lt;/ns2:Rows&gt;
  &lt;/ns2:Insert&gt;
  </code></pre>
  
  <p>Is there a way to fix this?  Really weird.  </p>
  
  <p>Thanks all!</p>