Load Data from multipe files into database
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
November 12th, 2012 5:24am

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
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2012 5:42am

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
November 12th, 2012 7:19am

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
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2012 3:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics