Last week, whilst doing a proof-of-concept for a customer in Melbourne, I was asked to demo a scheduled batch load from a BizTalk SQL Receive Adapter where the required rows (based on certain flags) are picked up at a scheduled time and then debatched
Read More...
On your receive port, there is a property called 'Poll While Data Found' , set this to True. This will ensure that the adapter will be polling the SQL DB continuously to retrieve data until there are no more rows (at that point it will actually switch
Read More...