Andy, you don't need a code. Brimg the foreachloop container and in the properties of it, make sure it returns full file path. create a variable and map this to this . bring bull insert and define connections. map this connections to that variables that you created. so everytime you reterive the full file path from folder that will be your connection string.

THANKS.