generating and emailing SQL query data? 1

[Hondy]

Hi

Can anyone tell me if its possible what I want to do?

I want to have a query run once a day and the output sent to CSV. Ideally I would then want this to be zipped and emailed.

Whats the best way to do this?

Thanks

 

[xlbo]

in Reporting Services?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Hondy]

Damn, thats in 2005 right? I'm using 2000 at the minute, soon to be replaced but for now I'm stuck with that.

Any options for SQL 2000?

 

[xlbo]

Nope - there is reporting services for 200 as well. That is what this forum is for.
My question is are you trying to do this via reporting services or through SQL Server.
If the former then you can use subscriptions and output to csv. If the latter then you are in the wrong forum!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Hondy]

Um, is this Reporting Solutions or Reporting Services forum? i'm getting all kinds of confused!

Would you be so kind as to elaborate a little? I have a SQL2000 server and I want automated query results churned out daily. Can this be done natively in SQL2000 or do I need to buy "Reporting Services" or am I in the wrong forum??

Cheers

 

[xlbo]

This is the Reporting Services forum (possibly need the name of the forum changing)

Reporting Services is a tool that is bundled with SQL Server 2000 and above. It needs its own report manager database and server to work properly. You design reports for it within visual studio.

If you already use this product, you can schedule a report to run on a daily basis and output as .csv file. If that is all you need this product to do then it is probably not worth while going through all the setup as there is probably a way to do it natively in SQL Server. I am not an SQL Server guru howerver so I would ask in the SQL Server Programming forum where the SQL nuts hang out

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Hondy]

Cheers Geoff, I will look into it!