I recently learned of a reporting services command line utility named RS.EXE.
There are a number of interesting SSRS problems that can be solved with a scripting interface. For example:
– How to move a group of reports from one folder to another folder?
– How to refresh a report snapshot in cache?
– How to publish a report?
– How to modify security permissions on multiple reports?
– How to trigger a subscription?
RS.EXE works by using Report Services Script (RSS) files that are written in VB.NET code, and since they can access the full SSRS API, ALL SSRS web service methods are available and accessible. Once the script is created, it is easy to replay this script in a repeatable manner.
More information can be found in SQL Server books online, use search keywords: rs.exe sample scripts are available.
I’d also recommend taking a look at utility named ‘Reporting Services Scripter’; which uses a GUI interface to create scripts used by RS.EXE.
Created by: Jasper Smith, SQL Server MVP
Reporting Services Scripter is a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another. It can also be used to easily move items on mass from one Reporting Services folder to another on the same server. Depending on the scripting options chosen, Reporting Services Scripter can also transfer all catalog item properties such as Descriptions, History options, Execution options (including report specific and shared schedules), Subscriptions (normal and data driven) and server side report parameters.