Link to home
Start Free TrialLog in
Avatar of ammartahir1978
ammartahir1978Flag for United Kingdom of Great Britain and Northern Ireland

asked on

how to create a report and email it to users

hi All,

i have a simple query which run fine and give me what i want, now i want to create a SP and then schedule this sp to run 4 times in a day and email the csv file to specific users.

is that possible? if yes how can i do it please.
Avatar of Mike McCracken
Mike McCracken

Are you trying to do this strictly in SQL Server or do you want to use a reporting tool like Crystal Reports.

I know this can be done with Crystal and a scheduling application.  I believe it can be done from SQL Server.

mlmcc
Avatar of ammartahir1978

ASKER

Hi Mlmcc thanks for your reply,

i dont mind any tool even a VB script in excel will do the job
ASKER CERTIFIED SOLUTION
Avatar of DcpKing
DcpKing
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hi Mike i am using sql 2000, SSIS is it available in SQL2000 , can you provide step by step guide so i can run my query?
good
SSIS isn't available until 2005, I'm afraid, but if you've got a 2005 copy on your system then you can use the SSIS on that to reach over to your 2000 system and use the data there. If it isn't for production, you can use a Developers Edition from 2005 onwards (about $50 plus postage from Amazon) - maybe use that to persuade your boss to get a copy of 2008 or 2012 !

You can do the extract part with DTS, which is available on 2000, and then use a script in DTS to invoke something like SendMail on the server box to send the email.

hth

Mike