| Hugo Rodger-Brown 2004-11-05, 2:46 am |
| Actions occur in BizTalk when a message is received, and that may occur
through a file drop or some other mechanism. This is supported through the
use of adapters in receive locations. The SQL adapter that you use in your
send scenario can also be used to receive data (as messages):
From the docs: "The SQL receive adapter is a polling service that
periodically polls for SQL result sets. A SQL command is stored in the
receive location configuration properties and is invoked by the Adapter
Framework scheduler. The SQL receive adapter supports SELECT statements and
stored procedure calls that each return single result sets."
This sounds exactly like what you are looking for. However...
"When using a SELECT statement to poll with the SQL receive adapter, the
receive adapter does not update or otherwise mark the records it retrieves.
The SQL receive adapter will continue to select the same rows according to
the WHERE clause contained within the SELECT statement."
You'll need to update the table / stored proc. to ensure that each
successive poll pulls out the next tranche of data (e.g. mark each lot as
read when the adapter calls the proc).
Look at ms-help://BTS_2004/Operations/htm/ebiz_ops_adapt_sql_esig.htm, or
search the documentation for "SQL receive adapter" for more information.
Hugo
http://hugo.rodger-brown.com
|