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