DataEnthusiast (9/9/2014)
Hey guys, here's an interesting scenario I encountered which I believe will be useful for all of us.Problem Statement:
The flat file souce should pick the file with keywords matching the filename. For example If there is a file File01_09042014 in the source location, the SSIS should look for keywords File01 in the source location and should pick up the File01_09040214 file. How do I design this.
Thank you.
I don't understand this part:
... pick the file with keywords matching the filename
Where do these keywords come from?
Are you just looking for files that start with one of these keywords, once the keywords have been established? How are they established?
Or are you just looking to process any file that exists in a certain folder?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.