asked
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 any of the answers below were helpful to you, please show that by clicking on the thumbs up next to the answer. If any of the answers below solved your problem, please indicate that by clicking on the check box.
All you need is to use SSRS's "Subscription" feature. Following are BOL lnks to get you started [File Share Delivery in Reporting Services][1] [Create, Modify, and Delete Standard Subscriptions][2] [1]:
http://technet.microsoft.com/en-us/library/ms159264.aspx [2]:
http://technet.microsoft.com/en-us/library/ms156307.aspx
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.
15 People are following this question.
