|
Home > Archive > BizTalk Server Applications Integration > February 2006 > Simple SQL Adapter Question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Simple SQL Adapter Question
|
|
|
| We want to poll a SQL Server table using a stored procedure in a receive
location. I know in BizTalk 2002, you could tell the adapter to send each
row from the result set as an individual message into BizTalk.
Can you do something similar with the SQL Adapter in BizTalk 2004? If I
have a resultset that is 200 rows, I don't necessarily want to send all 200
messages into my orchestration as one big message. I would rather have the
adapter send 200 single messages into the message box.
Is this possible?
Regards,
Chris
| |
| Jon Flanders 2006-02-06, 5:53 pm |
| Chris - you need to turn your SQL generated schema into an envelope schema
- this article http://msdn.microsoft.com/library/d...768ff245df1.asp
will show you how to do that.
Jon Flanders [MVP]
http://www.masteringbiztalk.com
http://www.quicklearn.com/workflow.htm
> We want to poll a SQL Server table using a stored procedure in a
> receive location. I know in BizTalk 2002, you could tell the adapter
> to send each row from the result set as an individual message into
> BizTalk.
>
> Can you do something similar with the SQL Adapter in BizTalk 2004? If
> I have a resultset that is 200 rows, I don't necessarily want to send
> all 200 messages into my orchestration as one big message. I would
> rather have the adapter send 200 single messages into the message box.
>
> Is this possible?
>
> Regards,
> Chris
|
|
|
|
|