Yes, each of them have the exact same table format and I have tried this strategy by putting the loop over this data flow.
I use the same transformation for each X Access files(where X can be from 1 to ?) every week. I just figured there should be a nicer way to do it all than manually...
Thanks for the response.
This method is basically the tutorial the Microsoft inclues. There must be some oddity to MS Access that thwarts my efforts of looping through an Access file.
Hi, and thank you in advance for any help you can provide.
My problem is fairly straightforward: I've been trying to find a way using SSIS to import an indefinate number of files(Microsoft Access actually) from a directory, and have been attempting this using a Foreach loop/container.
My...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.