| Author |
SQL Adaptor Sample for Receive and Send in same Orchestration
|
|
| Jack Barbosa 2005-11-29, 8:48 pm |
| Hi,
Does anyone have a step by step example for using SQL adaptor for receive
and send? I am a newbie here and have to implement BizTalk.
I have seen file to sql and sql to file examples but I can't seem to be able
to get the SQL to SQL to work.
Please help.
Jack
| |
| Marian Drumea 2005-11-29, 8:48 pm |
| I guess you want to first want to bring the data to the orchestration
and then loop through the records and call send for a stored procedures
with ID and Test as parameters.
This is my guess because you can also have a trivial stored procedure
that does exactly this in a line of SQL, without any parameters
required, and callable from an orchestration.
It would be great if you can confirm which of these is that you want
and I can take it from there.
Thanks,
Marian
http://www.MarianDrumea.com/BizTalk
| |
| Danny Buysse 2005-11-30, 2:49 am |
| Have a look at the SQL Adpater samples at
http://blogs.msdn.com/scottwoo/arch...3/11/88387.aspx
Danny Buysse
http://dannybuysse.blogspot.com/
"Jack Barbosa" wrote:
> Hi,
>
> Does anyone have a step by step example for using SQL adaptor for receive
> and send? I am a newbie here and have to implement BizTalk.
>
> I have seen file to sql and sql to file examples but I can't seem to be able
> to get the SQL to SQL to work.
>
> Please help.
>
> Jack
|
|
|
|