Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Jasper Smith's SSRS Scripter


Jasper Smith's SSRS Scripter

Author
Message
jhood 36885
jhood 36885
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
I know this is an old post, but I thought I would add what I found. I went to archive.org, and pasted in http://www.sqldbatips.com/showarticle.asp?ID=62 into the WayBackMachine and found the site. I then download the zip file from the cached copy of the website. Archive.org, a great project.
darkhelmutis
darkhelmutis
SSC-Enthusiastic
SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)

Group: General Forum Members
Points: 181 Visits: 840
jhood-

Thanks for the followup. I got a lot of great responses to this, including the one that pointed to the fact the SSRS scripter tool was rolled up into a larger project. Go figure!

I've used this before and it is the closest thing I know of to 'easily' merge and migrate SSRS instances. As much as Microsoft pushes SSRS as an enterprise reporting tool (and it is pretty good at that creating, serving reports), it is awful from a management perspective. I hope they improve that part of it moving forward. It should be easier to merge, split, migrate, and move an SSRS instance. However, I have heard ramblings that perhaps SSRS is going the way of the dinos...but no official confirmation!

Take care,
DH
lmacdonald
lmacdonald
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 513
Hi,

I have this tool but I have spent a day and still can't get it to work. I am able to select what I want to script and generate the script. I copy the folder over to the destination reporting server and run the "RS Scripter Load All Items.cmd" and in the log I keep getting the error below. I have many more reports to do but I just wanted to start small for the test. Both source and destination servers are SQL 2008R2.

Reporting Services Scripter Load Log 2.0.0.17

Starting Load at Mon 09/23/2013 14:56:29.95
SCRIPTLOCATION = C:\RSScripterzip\
REPORTSERVER = http://localhost/ReportServer
BACKUPLOCATION =
SCRIPTLEVEL = SQL2008
TIMEOUT = 60
RS = "C:\Program Files(x86)\Microsoft SQL Server\100\Tools\Binn\RS.EXE"

Running script "C:\RSScripterzip\OGS\Emailed\Weekly\ActiveProductCount.rdl.rss"
The system cannot find the path specified.

Running script "C:\RSScripterzip\OGS\Emailed\Weekly\CashAndSales.rdl.rss"
The system cannot find the path specified.
darkhelmutis
darkhelmutis
SSC-Enthusiastic
SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)

Group: General Forum Members
Points: 181 Visits: 840
Not sure, starting with the obvious: does that path reported in the error exist? Seriously, cut and paste it into explorer to make sure there isn't a typo? That is all I can think of right now.
lmacdonald
lmacdonald
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 513
Which path, the report server path or the path to the reports copied by the script? When I type in the localhost\reportserver the reporting server page comes up...
darkhelmutis
darkhelmutis
SSC-Enthusiastic
SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)

Group: General Forum Members
Points: 181 Visits: 840
The path included in the error message:

'C:\RSScripterzip\OGS\Emailed\Weekly\...'

Does that path (and the expected files) exist on the server on which you are trying to execute the CMD file generated by RSScripter?
lmacdonald
lmacdonald
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 513
Yes, if I put that path in explorer it goes to the rss file.
mister.magoo
mister.magoo
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2272 Visits: 7827
How about the path to RS.exe - is that right?

MM


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • jdean-1028471
    jdean-1028471
    Forum Newbie
    Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

    Group: General Forum Members
    Points: 4 Visits: 660
    It's nice to see RSScripter is still available, but is someone going to keep it up to date ? As the documentations states, it won't support anything new from SSRS 2008 R2 up, so shared datasets are not recognized by RSScripter. There is no tool better for SSRS report migrations around, so it's amazing no one is upgrading it. Is the source going to be available ?
    mister.magoo
    mister.magoo
    SSCrazy
    SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

    Group: General Forum Members
    Points: 2272 Visits: 7827
    jdean-1028471 (10/15/2013)
    It's nice to see RSScripter is still available, but is someone going to keep it up to date ? As the documentations states, it won't support anything new from SSRS 2008 R2 up, so shared datasets are not recognized by RSScripter. There is no tool better for SSRS report migrations around, so it's amazing no one is upgrading it. Is the source going to be available ?


    I don't think there is much chance of an update or getting our hands on the code, but it's not that hard and someone may come up with something to replace it ;-)

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search