I need to automatically generate via SQL, export to Excel and e-mailed
to other people montly. what should I setup in the sql server?
to other people montly. what should I setup in the sql server?
-
-
Re: automatic process
Much too vague to do anything but guess at an answer.
One wild idea is a Task that launches Excel which in turn runs a stored
procedure to return the results set into excel. Another task could send the
email with attached file.
Could also run a process from the OS level , running the query output into
excel and then email it.
"TedJM" <ted_gear@hotma il.com> wrote in message
news:55b4f192.0 412011101.15038 fe4@posting.goo gle.com...[color=blue]
>I need to automatically generate via SQL, export to Excel and e-mailed
> to other people montly. what should I setup in the sql server?[/color]
-
Re: automatic process
TedJM,
Take a look at Gadami: http://www.kripsoft.com. It's a program (EXE)
that lets you output the results of one or more SQL queries to Excel
and email them using an available SMTP server.
-Krip
Comment
-
Re: automatic process
The best way is to create a DTS package, that uses a query to output a
file with a pre-defined global variable as the path and file anme and
use sql mail to generate an email with an attachment..... And schedule
this DTS in a sql job...!
Comment
Comment