Hi all here my requirement is as follow SSIS package to import data from multiple excel files available in the folder into SQL Server database. How to create list of files from the input folder name including all the subfolders.Execute the loop of these filesEach loop will extract data from excel sheet into temp table in the database.Execute stored procedure to import data from temp table to main tableTruncate the temp tableLoop the step 2 onwards for the next file. End of all the files i am new to ssis ,i dont know how to do this ,if any one know can you please guide me. Thanks in Advance srikanth

go through the link below. It will guide you to follow steps by steps. let me know if you still face issue. http://dwhanalytics.wordpress.com/2011/03/16/using-ssis-loading-multiple-excel-files/ Thanks, Saikat

Hello, Follow the thread below. It may help you. http://stackoverflow.com/questions/7411741/how-to-loop-through-excel-files-and-load-them-into-a-database-using-ssis-package

hello, thanks for replay guys,but here path is not constant dynamically i will give the path.srikanth

hello, thanks for replay guys,but here path is not constant dynamically i will give the path. srikanth Then you just create a variable for the path and set up the Foreach file container with an expression for the path that uses the variableChuck

There is a custom 'for each' that can traverse sub-folders, and you can also apply a finicky mask to the file names to retrieve as a bonus, take a look http://microsoft-ssis.blogspot.ca/2012/04/custom-ssis-component-foreach-file.html if this may be of help to you.Arthur My Blog