Share This Post

Reporting Services Automation – enter RS.EXE

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

Overview

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.

http://www.sqldbatips.com/showarticle.asp?ID=62

Share This Post

Specializing in System Center Products: Configuration Manager 2007, Operations Manager 2007, Desired Configuration Management, SMS 2003, software distribution, ITMU, SUS & WSUS. Database products and solutions: Microsoft SQL Server 2005 & 2008, Business Intelligence Development Studio, Analysis Server, Reporting Services, Integration Services. Microsoft Windows Server 2003 & 2008, SharePoint, PerformancePoint, Active Directory, DNS, Group Policy, Security, VBScript, ASP, Visual Basic, WMI, HTML and XML.

Leave a Reply