SQLTeam.com | Weblogs | Forums

Unable to load multiple excel file into sql table using SSIS 2012



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 [57]] 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?