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

Posted by kgarske on Stack Overflow See other posts from Stack Overflow or by kgarske
Published on 2010-05-27T22:47:19Z Indexed on 2010/05/27 22:51 UTC
Read the original article Hit count: 166

Filed under:
|
|
|
|

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?

© Stack Overflow or respective owner

Related posts about sql

Related posts about wcf