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
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