RS.EXE Scripting Issue

Question

RS.EXE Scripting Issue

scout7-500377

SSC-Addicted

Points: 408
More actions
June 29, 2017 at 2:26 am

#324250

Hi, I have successfully created a VB Script for installing/updating reports to my report server so I have a good understanding of how this works.
Now I need to extend this script to perform another task of interacting with another database for auditing purposes.
Basically what I need to do is, after deploying reports using the script, Is as follows;
1. Access another database to get a list of report names
2. Using this list of names get ALL of the parameters for this report from the report server
3. Using the list of parameters I need to do some work with them and then serialize the results to XML
4. Write the serialized XML back to the original database
The above process has dependencies on 'System.Data', 'System.Data.SqlClient', 'System.Xml.Serialization' and 'Systems.Collection.Generic' (that I know of so far)
I have used Visual Studio to create and edit my script and I have gotten my logic to work exactly as I need when run through VS BUT when I try to add my changes to
my original RSS script they do not work, I get compilation errors.
I have tried using 'Imports' in the script to no fail and I now know that you cannot do that as the RSS script gets wrapped in a proxy and I have also tried to use fully qualified
namespaces i.e. 'System.Data.SqlClient.SqlConnection(ConnectionString)'
I get compilation errors such as the following;
Can I do what I am trying to do with just a script or do I need to create a console app or similar?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

You'll need something else. With rs.exe, you are limited to the methods, properties in the Report Server Web service.
It's documented in the remarks section of rs.exe:
RS.exe Utility

Sue

scout7-500377 SSC-Addicted Points: 408 More actions · Answer 2

Sue_H - Thursday, June 29, 2017 8:09 AM
You'll need something else. With rs.exe, you are limited to the methods, properties in the Report Server Web service.
It's documented in the remarks section of rs.exe:
RS.exe Utility
Sue

That is what I feared! I knew I should have written it as an app! Usual development process 'Are you sure you wont want to do anything else within this script?', 'No, that is the only requirement and it wont change', yeah right! 🙂

Lowell SSC Guru Points: 323518 More actions · Answer 3

this recent article and the follow up in the forum has a nice code example of getting all reports and all their parameters;
so you could use this and get your data via TSQL instead of however you are doing it now.
https://www.sqlservercentral.com/Forums/1865719/Dynamic-SSRS-report-documentation-via-a-ReportServerdboCatalog-query?PageIndex=2

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!