• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 547
  • Last Modified:

How do i use the Foreach Enumerator to loop through 10 Access .mdb files in a folder in SSIS

How do i use the  Foreach Enumerator to loop through 10 Access .mdb files in a folder in SSIS.
All that i have seen in on Text files and Excel files.
I need for Microsoft Access mdb files.
A picture/snap short view of the procedure would be appreciated
2 Solutions
Is the same as text files... the chane is the source..
take a look on here

1.  Double click foreach loop container
2.  In collection area, set Enumerator to "Foreach File Enumerator"
3.  Set "Folder:" to where ever you want to scan
4.  Under "Files:" set the box to "*.mdb"
5.  Variable mappings just set your "Variable" to the pre-defined variable and the index to 0.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now