SSRS deploying reports using RS.EXE command line video

By:   |   Updated: 2014-08-29   |   Comments (1)   |   Related: > Reporting Services Administration


Enter your business email address to
get free SQL Server tips.

Problem / Solution

SSRS 2012 reports can be deployed in various ways including:

  1. SQL Server Data Tools via the deploy option
  2. By manually going to the report server and uploading the RDL file
  3. Via the command line and the RS.EXE command utility

In this video tip we cover using the tool to deploy a report from your local directory to a report server. The utility has two required arguments:

  •  -i : denotes the input file, including the full or relative path, which will be run by RS.exe. This file must be written in Visual Basic .Net code and must have an rss extension and
  •  -s : denotes the SSRS server URL, such as http://myserver/ReportServer or https://myserver/ReportServer.

Additional arguments can be passed to the utility at runtime including the "-v" argument which allows variables to be passed to the script. The RS.exe program is generally found in the default installation directory: Tools> Binn directory; for my SQL Server 2012 installation the file was located in: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn.

Key Learning Items
  • Learn how to use RS.EXE to deploy a report
  • Learn about the use of the different arguments for RS.EXE
Read Companion Tip

Click Here

Last Updated: 2014-08-29

get scripts

next tip button

About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

View all my tips

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

Wednesday, May 31, 2017 - 3:24:34 AM - Shubhra Back To Top


 This has been really helpful, only if I want to provide username and password in teh command how can i do that.


Recommended Reading

PowerShell Commands for SQL Server Reporting Services

SQL Server Reporting Services (SSRS) Log Files for Troubleshooting

SSRS ReportServer Database Overview and Queries

Find Tables, Columns or Stored Procedures used in a SQL Server Reporting Services Report

SQL Server Reporting Services Rest API

get free sql tips
agree to terms

Learn more about SQL Server tools