I am looking to import a .CSV file on a daily basis. The file layout will be identical from day to day, however, the filename will change according to the date.
Example of filename:
GenericFileName20110428.csv - Day1
GenericFileName20110429.csv - Day2
GenericFileName20110430.csv - Day3
GenericFileName20110501.csv - Day4
The filename is consistent except for the change in the date.
Is SSIS the appropriate way to set up an automated task in this instance? I literally would like to import at a certain time every day from the same directory, looking for the specific file meeting the name match (excluding the date).
Thoughts? Suggestions? If this is the best way, I have set up SSIS import tasks before, but how would I accomplish it in this regard?