Single call for stored procedure from XI

Hi Friends,

I am using the stored procedure in target side, XI call the stored procedure each row to insert the record, Once successfully inserted log table is created,

so that thing i am using the stored procedure here.

We have lot of rows (that means lot of records)for ex 50000 records,presently in my scneario XI call the stored procedure for 50000 times to execute it.

So now i don't want like that, XI insert 50000 rows with in single call Stored Procedure is possible? can you please provide me your valubles?

Thank you very much.

Sateesh