But why do you need to use a For each loop? As mentioned by stewartc mentioned use batch size and commit size of 10,000 with TABLOCK option in the OLEDB Destination component, using TABLOCK option will speed up the data load operation. If you need more than 10K records to be processed increase the size to 100,000 (1 lakh).

Thanks,