How to Generate CSV file from SQL server tables and send it by email to recipients in an automated process
Posted on 2010-11-11
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.