I have monthly basis data in excel file.
In the excel source file, there is no column as Date.
The excel source filename will be saved as "Data_mmddyyyy" format (eg: Data1_06012016, Data2_06022016, and so on).
Like this every day a source file will be maintained.
Since there is no Date column in any source file, therefore is there any way to derive date from the excel source filename?