Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

Running a Reporting Services Script File

SQL Server 2008

Reporting Services script files are run from the command prompt using the Reporting Services script environment (RS.exe). RS.exe has many command prompt arguments available for you to use. For more information about the command prompt options, see rs Utility. For more script samples, see SQL Server Reporting Services Product Samples.

  • Run Script.rss in the script environment designating the target report server. Windows Authentication is applied by default:

    Copy 
    rs –i Script.rss -s http://servername/reportserver

  • Run Script.rss in the script environment specifying a user name and password for authenticating the Web service calls:

    Copy 
    rs –i Script.rss -s http://servername/reportserver -u myusername -p mypassword

  • Run Script.rss in the script environment specifying a server time-out of 30 seconds:

    Copy 
    rs –i Script.rss -s http://servername/reportserver -l 30

  • Run Script.rss in the script environment specifying a global script variable called report.

    Copy 
    rs –i Script.rss -s http://servername/reportserver -v report="Company Sales"

  • Run Script.rss in the script environment specifying that the Web service operations in the script file are run as a batch.

    Copy 
    rs –i Script.rss -s http://servername/reportserver -b
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Using MSBuild Deploy Reports
You can use MSBuild to run the rs.exe command to deploy reports by embedding the script inside the MSBuild file and executing the rs.exe. I have an MSBuild file that uploads RDL files, create folders and datasources:
http://www.danielflippance.com/blog/09-03-18/My_Favourite_MSBuild_Targets_3_DeployReports.aspx
History