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.
Create a folder and place the file there.
Use Database mail to send mail with attachment. Below the reference
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.