title: Biztalk 2013r2 wcf-sql adapter composite operation
body: <p>I am trying to use the wcf-sql adapter to call a stored procedure multiple times with different parameters. I have created the original schema using the wizard and then created the composite schema by hand. I understand what the error is telling me I just do not understand why I am getting the error and/or how to resolve it.</p>
  
  <blockquote>
    <p>Error: Microsoft.ServiceModel.Channels.Common.MetadataException:
    Object [dbo].[DEPT_NUM] of type StoredProcedure does not exist. The
    message that is suspended in Biztalk looks like this...</p>
  </blockquote>
  
  <pre><code>&lt;ns0:DINV_sumDepartmentInventory xmlns:ns0="http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo"&gt;&lt;ns0:DEPT_NUM&gt; 4&lt;/ns0:DEPT_NUM&gt;&lt;ns0:INV_DATE&gt;2016-03-21T00:00:00&lt;/ns0:INV_DATE&gt;&lt;ns0:USERNAME&gt;Service&lt;/ns0:USERNAME&gt;&lt;/ns0:DINV_sumDepartmentInventory&gt;
  </code></pre>
  
  <p>This is the portion of the orchestration...</p>
  
  <p><a href="https://i.stack.imgur.com/vyn78.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vyn78.png" alt="Ochestration"></a></p>
  
  <p>This is the map that is associated with the "transform_3" shape...</p>
  
  <p><a href="https://i.stack.imgur.com/LZesQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LZesQ.png" alt="enter image description here"></a></p>
  
  <p>This is what the composite schema looks like...</p>
  
  <p><a href="https://i.stack.imgur.com/j3neM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/j3neM.png" alt="enter image description here"></a></p>
  
  <p>I am expecting the output to more like this...</p>
  
  <pre><code>&lt;ns1:Request xmlns:ns1="http://BigY.PICSInventory.Updated_SQL_Schemas.Composite_SumDepartmentInventory" xmlns:ns0="http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo"&gt;&lt;ns0:DINV_sumDepartmentInventory&gt;&lt;ns0:DEPT_NUM&gt;4&lt;/ns0:DEPT_NUM&gt;&lt;ns0:INV_DATE&gt;2016-03-21T00:00:00&lt;/ns0:INV_DATE&gt;&lt;ns0:USERNAME&gt;Service&lt;/ns0:USERNAME&gt;&lt;/ns0:DINV_sumDepartmentInventory&gt;&lt;/ns1:Request&gt;
  </code></pre>
  
  <p>Any ideas what is wrong with the setup or what else I can try?</p>