Here i am loading multiple excel files with one sheet in each file having same meta data into one sql table.
I have used for each loop for this and created variables with source folder and file name and configured excel source connection with @sourcefolder+@Filename so that excel source will take each file from for each loop and process.
Here when i execute the pkg i was getting the below error on very first file
[Excel Source ] Error: Opening a rowset for "report1453396545505$" failed. Check that the object exists in the database.
[SSIS.Pipeline] Error: "Excel Source" failed validation and returned validation status "VS_ISBROKEN".
When i look back at preview in Excel source editor data is showing for this sheet, i am not finding the way to populate all files ..
can anyone help me on this?