asked on
How to Generate CSV file from SQL server tables and send it by email to recipients in an automated process
I have to generate a report using two tables in SQL server 2008 and send it in CSV format to recipients.
I have already written the query(Thats Okay) . How can I use reporting services ,SSRS to do this automatically . That is send the CSV file to email automatically everyday.
or SSIS or what other process can I use to do this and automate the whole process to go everyday.
Pls can you outline the steps very well and processes I should use.if there are little code involved too, pls let me have it.
I have already written the query(Thats Okay) . How can I use reporting services ,SSRS to do this automatically . That is send the CSV file to email automatically everyday.
or SSIS or what other process can I use to do this and automate the whole process to go everyday.
Pls can you outline the steps very well and processes I should use.if there are little code involved too, pls let me have it.
Microsoft SQL Server 2008SSRSMicrosoft SQL Server 2005
Last Comment
Alpesh Patel
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi,
Export data using the "BCP" and send mail using db_sendmail SP.
else
best way to Create SSIS packages.
Export data using the "BCP" and send mail using db_sendmail SP.
else
best way to Create SSIS packages.
Create a folder and place the file there.
Use Database mail to send mail with attachment. Below the reference
http://blogs.msdn.com/b/sqlagent/archive/2010/11/10/sql-database-mail-send-emails-with-attachment.aspx
Use a batch file to achieve the above steps. And schedule the batch file if needed.
Note; Use SQLCMD.exe to run sql scripts inside batch file.