September 3, 2014 at 12:34 pm
I can import one table, but how could I import 3 tables from one Access Database using SSIS? All the same fields from each table?
EDIT --
Let me clarify a little bit further. I know I would use the Foreach Loop Editor. But i am not sure which ForEach File Enumerator to select as The descriptions of each one (from best I can tell) do not describe iterating access tables.
September 4, 2014 at 3:23 am
Hi Jose
Please check this out: http://stackoverflow.com/questions/6298806/how-do-i-programmatically-get-the-list-of-ms-access-tables-within-an-ssis-packag
There's already been an extensive discussion about similar problem there, hope it can help with your case.
Br.
Mike
September 4, 2014 at 8:10 am
Can you elaborate on what that Script Task Code is doing in the link you provided? I am not 100% sure on what is taking place there and would like to understand 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply