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.