Reading Multiple Identical Tables from the Same Access database using SSIS
Posted on 2012-08-20
I have source data in a Microsoft Access 2007 - 2010. The database I am working with has a collection of tables that are "identical" except that they contain different data. They are named after the time period whose data they contain. I want to read them into a single SQL Server Table.
I know there is the Use Foreach Loop Container --> Foreach File Enumerator that you can use to cycle over a set of files, but that's not my case. I have a single Access database file (accdb) and want to cycle over all the tables in it. I won't know their names without manually inspecting them, and I'd prefer to not have that manual step. Any ideas?