Help in getting some samples for Excel -- sql server dts

John Rajendran
7/21/2003 10:08:25 AM

Hi there,
I am trying to get the SQL Data onto Excel sheets using
ActiveX Script in DTS. Is that the right approach. I am
also using some global variables in the SQL Task to get
the output parameters from stored procedure so that
source sql statement can be dynamically changed depending
on the users requirement. Now the issue is I want to have
the Excel generated as well dynamically (file name
obtained from the SP and the formatting done at the
ActiveX script. Can anyone help me to find some sample
scripts to accomplish the Excel implementation.

Thanks

JFB
7/21/2003 4:21:04 PM

Hi John,
From here you can get the idea, this is for text file but it should be the
same for excel.
http://www.sqldts.com/default.aspx?6,101,200,0,0
JFB

[quoted text, click to view]

sql server dts : Help in getting some samples for Excel