I've been struggling with the example in the link you provided. The author leaves out steps (and refers to things in figure 3 that show something different than what...

Thanks Phil! Sorry I didn't see the link. That's what I get for working in a dark room with the laptop on battery (dim screen). I will...

Thanks Lowell. The table is named the same as the file name. How would I use this dynamically ?

Thanks "Get me?" but how would I do that? Would I have to open each file to create the view? Thanks.

Thanks Phil, but where is the example? I do have a foreach loop that dynamically changes to connect in turn to each Access db's filename. The table name...

Does this help?

I've just been working with this setting recently because I needed to set it to "False" so that I could import MS Access DBs.

Thanks! That worked perfectly!

In what way isn't it working? Did you see any error messages? Here's a link but I'm not sure if it applies to your situation: Access/SSIS[/url]

Thank you for your reply but I am wondering how to do it. I see how to do it via the Stairway on this site for an OLE DB...

I just want to thank you again Phil. I did as you advised for all the flat file and Excel file types I have to import and everything worked...

Thanks Mike. I'm nor sure about what you mean. Each data flow task has its own flat file connection, each flat flat file source is a different flat file...

Thanks very much Phil. I'm going to implement what you've told me and I will post my results here.

To handle the varying file names, use FOREACH containers. An example file spec would be ProdSmallCellCarcinoma_*.csv. The fact that it will iterate over only one file is not a problem.

The...

Thanks Phil.

Thanks pietlinden, I will do this. By tomorrow I will post...