Hi I have 5 csv files to load one table.Currently i created one simple package, in data flow task i took flatfile source and oledb destination.To load 5 fiels currently i am executing the package 5 times.Instead of that I want execute 5 files in one execution.How to implement this logic in exsting package? Thanks CMK..

have u tried For each container in ssis.check this how to configure a for each loop in ssis http://www.bidn.com/blogs/DonnyJohns/ssas/1692/ssis-package-containers-part-5-foreach-loop-containers

hope it can helps you. http://www.codeproject.com/Tips/378129/In-SSIS-Dynamically-Configure-Excel-in-For-Each-Lo