RsScripter - possible bug, ok to decompile?

• JohnHennesey

  Valued Member

  Points: 50

  More actions

  November 25, 2016 at 6:06 pm

  #332262

  I still use the "little tool that could" - RsScripter - works [almost] perfectly for me, but I think I found a bug. Only problem is I think the code is no longer maintained... I posted something on SqlServer FineBuild over here, and was recommended to post in SqlServerCental as it is has a more active user base. I am reposting here in hopes of an answer... also, if the code base is no longer active does anyone know if it is safe to decompile to modify? (I did reach out to all the email addresses in the logs, documentation, etc. and didn't hear back)

  Thank you in advance, John

  ------ The repost

  I am using RsScripterCmd to script out a folder from our reporting site - it appears to be pulling in all folders that start with what I am specifying. Has anyone seen this? I tried a few variations but have not been able to get past it. For example when I specify in the input file [see below] it scripts out the folders and contents for:

  /Breeze

  /BreezeBi

  /DataSources

  I am after only the /Breeze and /DataSources folders... But it looks like it is pulling in /BreezeBi because it starts with /Breeze?

  <?xml version="1.0" ?>

  <RSCatalog>

  <CatalogItems>

  <CatalogItem Path="/Breeze" Recursive="True" />

  <CatalogItem Path="/Data Sources" Recursive="True" />

  </CatalogItems>

  </RSCatalog>

  And the log:

  ** Reporting Services Scripter Cmd 2.0.0.17 Log File **

  ** Source : http://www.sqldbatips.com/showarticle.asp?ID=62 **

  ** Author : Jasper Smith (jas@sqldbatips.com) **

  ** Bugs/Enhancements : rsbugs@sqldbatips.com **

  Starting scripting at 11/20/2016 7:53:27 AM

  Input Parameters

  inputfile = C:\tmp\BreezeStandardReports.xml

  sourceurl = http://svr-mango/reportserver_qaTip/ReportService2005.asmx

  configfile = C:\tmp\RSScripter.cfg

  outputfolder = C:\tmp\BreezeReportsQaTip

  logfile = C:\tmp\Out.log

  dumprdl = False

  loadrdl = False

  targetfolder =

  sourcefolder =

  Scripting Progress

  7:53:27 AM Input parameters parsed successfully

  7:53:27 AM User Settings loaded successfully

  7:53:28 AM Reporting Services connection initialised successfully

  7:53:28 AM Reporting Services catalog fetched successfully

  7:53:29 AM Reporting Services Schedules fetched successfully

  7:53:29 AM Reporting Services Roles fetched successfully

  7:53:29 AM Inputfile loaded successfully

  7:53:29 AM Loading Catalog Items to script

  7:53:29 AM Added Catalog Item "/BREEZE" to Script Collection

  -- removed many for privacy - and it picks back up here

  7:53:29 AM Added Catalog Item "/BREEZEBI/CHARTS" to Script Collection

  7:53:29 AM Added Catalog Item "/BREEZEBI/CHARTS/ADJUSTER CASELOAD - CLOSED CLAIMS" to Script Collection

  7:53:29 AM Added Catalog Item "/BREEZEBI/CHARTS/ADJUSTER CASELOAD - OPEN CLAIMS" to Script Collection

  7:53:29 AM Added Catalog Item "/BREEZEBI/CHARTS/AGENCY BRANCH BY WRITTEN PREMIUM - BOTTOM 10" to Script Collection

  Update

  When searching through the catalog items on the report server it appears to do a .net StartsWith on the name vs. an ==. This was verified by creating two new folders at the sibling level of Breeze - "JohnBreezeTmp" and "BreezeTmp" - the "BreezeTmp" folder was also picked up.

  7:45:56 AM Added Catalog Item "/BREEZETMP" to Script Collection

  7:45:56 AM Added Catalog Item "/BREEZETMP/OVERVIEW" to Script Collection

  Does anybody know if the source code is available to be downloaded/modified? Been looking for it for over a year now, finally asking the community. 🙂