question

ncmendiola avatar image
ncmendiola 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.
ssisssrssubscriptions
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Usman Butt avatar image
Usman Butt answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.