I want to import tables from one sql server to another server using SSIS with loop I want to import table via SSIS, This package will execute like first it'll import first 10 tables once its imported then it'll start to import 10-20 tables, like a loop. 

Can anyone explain me how can I achieve this?
Maybe you just don't even need a foreach loop and can use the Rows per batch setting of the destination :



But, well, I don't know how is your package so I'm not sure it fits...