I have an excel file I am importing into a table. The excel file is named with a date (02102010_Excel_file.xls).
I created a very simple import package. This simple two object package - Excel Source to OLE DB destination works just fine.
My problem is that the Excel file name will change every day to todays date (09162010_ExcelFile.xls) So, I need to change my Excel Import to something like *.xls but that doesn't work.
How can I Import a *.xls file?
View Complete Post