Hi can be the target would be multiple excel sheet..i got a situation where i have to load into one excel file with multiple sheets..wht is the solution in ssis..

You can use multiple excel source and make use of UNION ALL/MERGE Or MERGE JOIN based upon your requirement. If all the excel files have same structure and are located together, you can also make use of ForEachLoop to iterate through all the files and then use a data flow task to move the data from each excel file to target file. You have to change the excel connection string dynamically at each iteration of the for each loop.Nitesh Rai- Please mark the post as answered if it answers your question

@Nitesh...Can you post a link which has the sample implementation?