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.
The ExecuteSQL task is not the one you want here.
What you need is a DataFlow and inside that DataFlow you should should put an OLEDB source pointing to your stored proc.
Then create your Excel destination and join the two - you should be able to do your column mapping from there.
Note that if your stored proc selects from a temp table you may need additional guidance before SSIS 'recognises' the columns.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.