SSIS is indeed able to compose dynamic strings (you just use programmatic tools inside ssis, so again, its not really the native tools). I meant that there is not way to output into excel dynamically with the native ssis tools.
I'm aware of the limitations of Excel. Thank you for the reply. 🙂
I eventually used .NET code and created a small program that creates and gets the data into an excel file (using the EPPlus library). 🙂