CODEWITHSUNDEEP
sqlwcfbiztalkportsend
kgarske
kgarske

Reputation: 379

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

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?

Upvotes: 3

Views: 6404

Answers (1)

Derek Beattie
Derek Beattie

Reputation: 9478

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.

Upvotes: 2

Related Questions