This document provides documentation on how to install and use the Universal Task for SQL Server Reporting Services.
The Universal Task described here calls a script to deploy a report on the Reporting Services Webserver.
This Universal Task is based on the SQL Server Reporting Services RS.EXE utility. RS.EXE is a command line utility that can perform many scripted operations related to SQL Server Reporting Services (SSRS). It can be used to complete various administrative tasks including publishing reports and moving reports from one server to another server. The RS.exe utility requires an input file to tell the RS.EXE "what to do". The list of actual tasks that can be performed includes, among others:
Deploying / publishing reports
Exporting reports to a file
Cancel a running job
Configure SSRS system properties
The Universal Task described here calls a script to deploy a report (#1 in the list above). Points 2-6 in the list above can also be implemented via a script called by the Universal Task.
Software Requirements for Universal Agent
Universal Agent for Linux or Windows Version 18.104.22.168 or later is required.
Software Requirements for Universal Controller
Universal Controller 22.214.171.124 or later is required.
Import the Microsoft SQL: Schedule SSRS Universal Template
To use theMicrosoft SQL: Schedule SSRS Template, you first must perform the following steps:
This Universal Task requires the Resolvable Credentials feature. Check that the Resolvable Credentials Permitted system property has been set to true. For more information about Resolvable Credentials click here.