• @anthony.

    Do you mean change the FlatFileConnection on each loop (i.e. 10 FFCs and choose each one dynamically) or do you mean one FFC and change it's source in each loop.

    To be honest, if it is really only 10 folders and the folders are static, I would just set up 10 bulk insert tasks with 10 FFCs and be done with it 😉