Calling Stored Procedures Using the SQL Adapter

Calling Stored Procedures Using the SQL Adapter<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

 

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.