I have a directory(Main), in that there is a folder (Sub), which has further subfolders (e.g. 20120101,20120202,20120303,20120404..etc). What I need to do is, get the .txt files from Date1,Date2,Date3,Date4..etc respectively and load them daily in to my SQL table. Is there any way to accomplish this?
E.g. The package that will run tomorrow morning (11/25/2012) will load the text file from yesterday (20121124). For my testing purposes, I want to load all the text files from these folders in my package.