Traverse Subfolders / Foreachloop
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
October 29th, 2011 2:36pm

Hi KDW, There is a checkbox option to traverse subfolders. It's location here: Tom Overton
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2011 3:00pm

Hi Tom - I used it - ...it does not seem to have any effect - it is only using the directory that I have explicitly stated ...do i need to change my ocnnection manager string?KDW
October 29th, 2011 3:07pm

I think you also need the "Fully qualified" radio button selected. Do you have that selected?Tom Overton
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2011 3:14pm

I also needed to write to the connection string variable and use that as my connection stringKDW
October 29th, 2011 4:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics