Solved

Email sql query results as CSV

Posted on 2008-10-02
3
889 Views
Last Modified: 2012-05-05
I have a straightforward sql select query and I would like to send the reults by email once an hour or so, with the data in a csv - is that easy enough to do or do I need some third party software?
0
Comment
Question by:Lapchien
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 25

Expert Comment

by:jogos
ID: 22622236
In SQL*Server there is a tool for that SSIS   Sql*Server integration services
0
 
LVL 25

Accepted Solution

by:
jogos earned 400 total points
ID: 22622282
A little more explanation (this link is about DTS for SQL2000, which is replaced by SSIS in SQL2005)
http://support.microsoft.com/kb/319951
0
 
LVL 3

Assisted Solution

by:abhijit_k
abhijit_k earned 100 total points
ID: 22632613
U can use SQL Database Mail Setup and configure to send mail. xp_sendmail PRoc can be used for the same.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question