[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

dts to excel with dynamic file name

Ganesh

3/26/2007 7:23:00 PM

Hi there,

What;s the best way to create auto excel in a directory with diferent
filenames each days from stored procedure. write dts and call dts thru jobs
or something else

is there any sample code available to look from any web site. I know how to
do it from query from excel with fixed file name. But need some advice to
pass the file name thru dynamic variables.

sql 2005 supports dts package?

Thanks
Ganapathi