andy.westgate (6/18/2013)
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.