To the OP (if still around) did you solve this easily?

This is also the problem I am having.

I want to execute a stored proc and output the results to an excel file. I can set up an exec sql task fine but when I try map it to an excel destination it won't recognise any columns and when I build the execl sql task is says the exec sql construct or statement not supported.

When I try a script component it won't recognise any input columns.

It feels like this should be easy but I think I missing something simple somewhere.

Any help greatly appreciated.