This project has moved. For the latest updates, please go here.

RsScripterCmd pulling in more folders than specified (starts with)

Nov 20, 2016 at 11:56 AM
Edited Nov 21, 2016 at 11:58 AM
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 : 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. :)
Coordinator
Nov 23, 2016 at 2:56 PM
Very few people monitor this forum. You are more likely to get an answer using SQLServerCentral which has over 1 million people looking at it.
Marked as answer by JohnHennesey on 11/25/2016 at 5:08 PM
Nov 26, 2016 at 12:08 AM
Edited Nov 26, 2016 at 12:18 AM
Done - Thank you!

http://www.sqlservercentral.com/Forums/Topic1837929-150-1.aspx

I seem to be unable to get a hold of Jasper Smith - Do you know if the source code is available for consumption / modification?

Thank you in advance,
John
Marked as answer by JohnHennesey on 11/25/2016 at 5:08 PM