ssis - open folder and capture the folder name

harry88
harry88 used Ask the Experts™
on
01-21-2010
02-23-2010
....
.....
.....
08-22-2010 so on

I have this folders and i need to capture the folder name and also open all the files in each folder and read them and load them to DB.
I know how to do this for one folder and files inside it.

My question here-- how to loop this for all folders, what kind of consition should i place in FOREACH task to accomplish this.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Consultant, Trainer
Commented:
all of these folders are in one parent folder or not?
if yes, use Traverse SubFolders option in foreach loop editor.

if no, you should use another foreach loop to loops through folders, and then put your current foreach inside parent foreach.
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
Commented:
image

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial