I have about 2 years of files to loop through and load. Each of my source files is named the same so I've put togetther a package which loads files successfully - but I'm trying to loop through each of the months directories and loading the files so - if my source root is C\:FilesToProcess and this is where my foreachloop is pointing to. Then I am using store.txt as my file source Now in C:\FilesToProcess\November2010\store.txt is not being picked up - In the foreachloop i have traverse subfolders checked so why will this not pick up my files in the subfolders of C\:FilesToProcess? KDW

Hi KDW, There is a checkbox option to traverse subfolders. It's location here: Tom Overton

I think you also need the "Fully qualified" radio button selected. Do you have that selected?Tom Overton

I also needed to write to the connection string variable and use that as my connection stringKDW