How to create and map excel destination dynamically
In the earlier post we learned how to map excel destination directly in the SSIS in this post we lean to create excel sheets dynamically in a single excel file
we modify the package in the above post slightly to achieve our task here
Sqljunkieshare 
i am trying with multiple sheet creation in single workbook can u provide example for that