How to loop through the folder and files in ssis

Question

I have a folder let say (Main folder), which could have sub folders based on the employee id ex ( 67,68,78,92.. etc) which means that employee 67,68, 78 and 92 has uploaded some excel files to their folder. How can I loop through all sub folders and their files one by one.

In the beginning, I have only main folder. I am not aware that which employee is going to upload how many excel sheet for a particular month.

enter image description here

billinkc · Accepted Answer · 2012-02-15 22:08:13Z

11

You need to use the "Foreach Loop Container". When you double-click it, go to "Collection" and choose the "Foreach File Enumerator". Once you do that, it will ask for the folder that contains the files, here you have to choose your Main folder. Then you need to check the "Traverse subfolders" checkbox and that should do it.

Looping over files with the Foreach Loop

edited Feb 15, 2012 at 22:08

billinkc

61.4k10 gold badges110 silver badges169 bronze badges

answered Feb 15, 2012 at 21:56

Lamak

70.8k12 gold badges119 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to loop through the folder and files in ssis

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related