Skip to Content
0
Dec 12, 2011 at 09:54 PM

Help with Excel Source, multiple files, same names, different directories

160 Views

Can you please lend your expertise?

We have a directory structure like the following:

..\[State Name]\[Site Name]\FileA.xls

..\[State Name]\[Site Name]\FileB.xls

...

And I would like to import some data from all the FileA.xls files on the directory structure. All of the data is in the same spot (rows/cols) so I would think this wouldn't be too hard. Now I could define all the paths I suppose (160 of them or so) but that would not scale well as some are added or removed etc.

I have tried all different types of combinations for wild cards without success which I was expecting to work based on the documentation mentioning use of wildcards for directories are supported (I have a feeling it works on linux maybe? we are running windows).

Any ideas how to accomplish this task in data services designer? Does the script language in a while loop allow some sort of directory scan?

Thanks,

Aaron