SSIS Excel to SQL Server - Need to add SSIS variables into the mix
Does the Excel Connection Manager use a variable for the file name (ExcelFilePath property)?  If so, try adding a derived column with this variable as the value.  Otherwise you can add a Script Component within the Data Flow Task as follows to create a new column that will hold the file path.


Add a Script Component.  On the Input and Outputs pane, expand the Output 0 folder, select the Output Columns folder and add a new column.  Name this column as you want the column holding the file name to be named and pick the proper data type.
On the Connection Managers pane of the Script Component, add the Excel Connection Manager that is being used and provide an appropriate name for the Name property. 
In the script, the following code will obtain the file name and set the new column to this value from the IDTSConnectionManager100 object.  In this example, ExcelConnection is the name that was given to the Excel Connection Manager on the Script Component editor and ExcelFilePath is the name of the new column that was added in the Data Flow.  From this point, the new column can be mapped to the corresponding column in the destination table.

IDTSConnectionManager100 ConnMnger;
ConnMnger = this.Connections.ExcelConnection;

Row.ExcelFilePath = ConnMnger.ConnectionString;