Hi,

I need the ability to export any sql statement or stored procedure (with
parameters) to an excel file at will. Anyone know how to put that into a DTS

i think when you use the Transformation Task, you are able to choose SQL
query instead of Table / View...
For Stored Procedure, you might want to use UDF to replace the stored
procedure, for the parameters, you might use Dynamic Preperty Task or refer
to the follow link
(http://www.sqldts.com/default.aspx?205)


[quoted text, click to view]