How to automate an ssrs report on a daily basis to be saved in a web folder?
I created a calendar report in SSRS that has a date parameter that I choose for next day events. I have to run on a daily basis around 4:30 pm. This report has to be saved in a folder (..inetpub/wwwroot/calendar/calendar.html) that gets saved in a folder and gets displayed over the net. Can this report be automated with SSIS and SSRS? How would you automate this? I am not sure. Thank you for any assistance.
If the target folder is accessible as Windows File Share, than the easies way is to use the Report Subscription and File Share Delivery method ans @Usman mentioned. If you cannot access the folder as file share, but for example need to upload it to FTP, or use other methods, than you can even use SSIS to deliver the Report. In SSIS you create a Script Task and inside the script task you create WebRequest to render the report in appropriate format. Than the reulst you can save using whatever possibility you have in C#,
VB.Net or simply save it to a temporary file and then process subsequenty by other subsequent tasks inside the SSIS Package.