Scenario:I will get a set of 500 records into temp table,and i want to delete all the 500 records based on the id in temptable.
Then problem is if i pass one id at a time and delete the records I have to hit the db 500 time.
Is there any way we can process this like a batch execution.
First I will pass 50 records from temp table and then i will pass another 50 like that.
How can i pass multiple id value to stored procedure ssis.
View Complete Post