for each items execute SP

here in the save contracts in header table am saving multiple contract_id to the table at a time. but SP will execute only one contract_id at a time to load the data to another table...

so i want to execute SP for all the contract_id... it can be possible using for each id SP has to execute ? if so let me know how can i achieve this 

here we can use script tasks if required. 

so i can query all the contract_ids.. but how to execute this SP for each of those items