How Do I Execute A Stored Procedure From A BizTalk SendPort?

Question

Hello,

I would like to call a stored procedure from a SendPort. I want to avoid an orchestration and instead, create a subscription to the message box based on the receive port and message type. I also need to use attributes from the received message xml as parameters for my stored procedure.

My assumption is that I should use WCF-SQL adapter. However, the only examples I have found require a 20 step process and some magic/luck... oh yeah, and an orchestration. Am I crazy for thinking this should be way simpler than it seems? Can anyone provide me with resources or advice?

Answer 1

Is one of the examples you looked at the excerpt from Richard Seroter's book? http://www.packtpub.com/article/soa-capabilities-in-bizTalk-wcf

What you want to do can be done without an Orchestration.