[font="Verdana"]I came across with a very detailed example. Please refer : http://stackoverflow.com/questions/7411741/how-to-loop-through-excel-files-and-load-them-into-a-database-using-ssis-package

[/font]