Export any SQL/SP to Excel - 01-27-2005 , 06:41 PM
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
package, or know of a premade one available somewhere?
RE: Export any SQL/SP to Excel - 01-28-2005 , 04:17 PM
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