I am creating a SSIS package, in which I am trying to create multiple excel files with 2 worksheets in each file. I can do this by using foreach loop container and flat files but I am not able to do this with excel files. I am able to create a dynamic file but each time the loop runs instead of creating new file it just overwrites the existing excel file. But the same approach works by using flat files.
