|
Home > Archive > BizTalk Server General > July 2004 > BizTalk Server 2004 and SQL Adapter
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 |
BizTalk Server 2004 and SQL Adapter
|
|
| Srinivas Rayaprolu 2004-07-27, 7:55 am |
| I need to use SQL adapter to retreive the results from SQL
adapter and process those records using BizTalk
Orchestration. I don't know the number of records my query
is going to retrieve. To reduce the risk, I don't want to
retrieve all the records at a time. I need to retrieve in
chunks of 100 at a time and process those and then
retrieve next 100 records. Is there any way I can
implement this solution using SQL Adapter in BizTalk
Server 2004.
Please let me know, if require more information on this
problem.
Thanks and Regards,
Srini
| |
| Yossi Dahan 2004-07-27, 7:55 am |
| Well, two things that come in mind are -
use stored procedure instead of a simple select or
use the TOP n in the select statement
didn't try the second one but it should work.
Yossi
"Srinivas Rayaprolu" <Srinivas_rv_2001@yahoo.com> wrote in message
news:4d2501c473bd$fc44d880$a501280a@phx.gbl...
> I need to use SQL adapter to retreive the results from SQL
> adapter and process those records using BizTalk
> Orchestration. I don't know the number of records my query
> is going to retrieve. To reduce the risk, I don't want to
> retrieve all the records at a time. I need to retrieve in
> chunks of 100 at a time and process those and then
> retrieve next 100 records. Is there any way I can
> implement this solution using SQL Adapter in BizTalk
> Server 2004.
> Please let me know, if require more information on this
> problem.
>
> Thanks and Regards,
> Srini
|
|
|
|
|