I currently use a set of cmd scripts wrapped around RS.exe and vb script for extracting reports from a "base" folder, and deploying the new reports to N number of client folders. The performance for the report extraction is very fast.
It extracts all of our reports (about 100 reports all total).
The extract portion takes about 1 minute. The delete portion takes less than 1 minute, but the deploy portion takes up to 30 mins per client! So basically I can only deploy reports to 2 clients/hr which doesn't scale well.
I basically use a parent program to generate a vb script to deploy each report. The following vb script would be saved to a Report-1.rss file, and ran with RS.exe against our Reporting Services server URL. So the net effect is running RS.exe
100 times with the following script, just didn't report RDLs and paths.
From your experience, should running this script 100 times take 30 mins? The reports are small in total byte-size and not terribly complicated. I thought something like this would take 10 mins tops to deploy considering how fast our other .net
& SQL deployment run.
Public Sub Main()
Dim name As String = "A. Report-1"
Dim parent As String = "/Client-1/Product-1/1. Sub-Folder-1"
Dim location As String = "Cli
View Complete Post