From reading your post I understand the situation to be:
It sounds like you need to read a table to get the name of the current Excel file to be processed
Using this Excel filename you need to process the file and load the contents to your database
One approach you could look into involves the usage of a variable to store the Excel filename to be processed. You could read the filename from your source table and assign the filename to a variable. You could then use an Excel source and connection manager to read your file based on the variable that you populated with the filename.
What you want to do with SSIS can be done.