I want to import tables from one sql server to another server using SSIS with loop
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...