Hi All


How to call a stored procedure with in an orchestration other than making us
e of .net component ?
Any thoughts ?

Regards
Guru

[ Post a follow-up to this message ]

Hi

Having a solicit response port with the SQL Adapter called from the
orchestration and returning the result is one way..

Yossi


"System.Xml.XmlDocument" <SystemXmlXmlDocument@discussions.microsoft.com>
wrote in message news:EF7D2898-A56D-4299-B24E-CB93568FFAC9@microsoft.com...
> Hi All
>
>
> How to call a stored procedure with in an orchestration other than making
use of .net component ?
> Any thoughts ?
>
> Regards
> Guru
>

[ Post a follow-up to this message ]

Scott Woodgate has a great document on using the SQL adapter,

http://blogs.msdn.com/scottwoo/arch...3/11/88387.aspx

the 5th example shows how to call a stored procedure from inside and
orchestration.

Bill Chesnut
BizTalk MVP

"System.Xml.XmlDocument" <SystemXmlXmlDocument@discussions.microsoft.com>
wrote in message news:EF7D2898-A56D-4299-B24E-CB93568FFAC9@microsoft.com...
> Hi All
>
>
> How to call a stored procedure with in an orchestration other than making
use of .net component ?
> Any thoughts ?
>
> Regards
> Guru
>

[ Post a follow-up to this message ]