Hi I have Multiple Excel Files(2007) That are Stored in Different Directories in a main Directory Like and some times I will have Multiple sheets in each workbook
And I have a Table (FileList) on My Database with Structure
ID, MainDir, SubDir, FileName,Sheetname, FileDate
What I have to do is, I need to Populate this table with all that information from the Files.
I need to do it in SSIS 2005
Any Help would be Appreciated.. Thanks in Advance..