multiple Project source files (of same format) present in the Project folder Need to load data from each of the Project source excel files, into the databaseShanmugaRaj

Hi Shanmuga raj, go through this link it might be helpfull for your secnario http://bi-polar23.blogspot.co.uk/2007/08/loading-multiple-excel-files-with-ssis.html thanks RRavila

In the page, point no 17, . Edit the Foreach Loop Container so that it loops through all xls files in the folder and retrieves the fully qualified file name and maps that value to the FileName variable Its not happeing.. ShanmugaRaj

Hi ShanmugaRaj, You need map the excel files to the connection. Click on the Excel connection in the connection manager, Click on Expressions in the properties windows and open the expressions editor for the Excel connection manager. Select the ExcelFilePath property and drag in the variable which stores the file path in. For more details about it, please see: http://www.bidn.com/blogs/MikeDavis/ssis/625/loop-through-excel-file-in-ssis and http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-foreach-loop-file.html Thanks, EileenEileen Zhao TechNet Community Support