SSIS package - send records to webservice

Question

Hello Guys
 
I am facing one issue on ssis.
I have to fatch 100 record with pending status from DB and send to web service. on response of web service would get same 100 record and same need to update with completed status in DB. Now again I have to fatch 100 record with pending status..... so I have to execute ssis package till record with completed status.
plz let me know how I can execute ssis package till all record update.

Answer 1

In SSIS, you a for loop container and a "for each loop container" and a "for loop container", you set your looping conditions on those and insert the task to do inside them. You also have a "web service task".

Instead of calling the SSIS multiple time, I would look to use those possibilities. 

If you want to call the SSIS often, just put it in a scheduled job using the agent.

Answer 2

Sorry do you mean records keep on adding with pending status whilst you're processing first set of 100 records?

---

Please Mark This As Answer if it solved your issue
Please Mark This As Helpful if it helps to solve your issue
Visakh
----------------------------
My MSDN Page
My Personal Blog
My Facebook Page