idogal (12/18/2012)
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 don't think you need any tool for this as this can be achieve by setting expressions with the help of some variable declaration.