Integration

I have created a bpel database polling process to process a single table and use a logical update (mark a column as processed). The table will contain many unprocessed records at any time. I have setup the polling interval 5 Sec and records unlimited for each polling interval and in the process i am calling a stored procedure to insert same data into another database.

My doubts

But It fetches only one record and different instance is created for every Row. Is it normal process?

Why it takes only record after using unlimited option?

why i am asking this means i don't want to call stored procedure for each and every record.

I'm using MS SQL Server 2005.

any one pls let me know what is happening inside.