HI,

  I have a folder in that 3 excel  files,  each excel file i want to move 3 different destinations(each file go to single destination), 

if another time in same folder have 5  excel files, each file i have to move 5 different destinations

please help me

Hi Koteswararao,

What drives the logic for the destinations?

While  I'm awaiting reply, typically this is achieved by directing the flow using the precedence constraints https://www.simple-talk.com/sql/ssis/working-with-precedence-constraints-in-sql-server-integration-services/

Hi Koteswararao,

Based on your description, you want to load data from multiple excel files in a folder to multiple destinations.

If there are no any blank sheets in the Excel files, all the sheets follow the exact same structure and also all excel files using the same file extension, then we can use two Foreach Loop Containers with a Data Flow Task to achieve your requirement. For more details, please refer to the following similar thread:
http://stackoverflow.com/questions/7411741/how-to-loop-through-excel-files-and-load-them-into-a-database-using-ssis-package

If it is not, then we may need to use multiple Data Flow Tasks, one for one file extracting data. Because Data flow task doesn't support dynamic metadata.

Thanks,
Katherine Xiong