Calling Stored Procedures Using the SQL Adapter
Calling Stored Procedures Using the SQL Adapter
When in the SQL Transport Schema Generation Wizard, you have to specify the Target namespace and Response root.
Let’s assume that you specify these values as below.
Target namespace: http://SQLAdapterStoredProcedure
Response root: ResponseRoot
By doing this, BizTalk generates a schema with this typename:
http:// SQLAdapterStoredProcedure#ResponseRoot
Then, when your orchestration calls the SQL port, and gets a response, that response's message type should match that of the generated schema.
In BizTalk explorer, make sure you have the SQL send port configured right when creating the physical BizTalk port. i.e., the Document Target Namespace and Response Root Element Name need to match those above.
In addition, Set Send Pipeline to the Microsoft.BizTalk.DefaultPipelines.XMLTransmit pipeline.