SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Jasper Smith's SSRS Scripter


Jasper Smith's SSRS Scripter

Author
Message
asheppardwork
asheppardwork
Old Hand
Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)

Group: General Forum Members
Points: 307 Visits: 164
Did you ever resolve your issues? Will it work on 2008 R2? both my environs are 2008 R2 and I need to migrate from Integrated mode back to Native mode.
asheppardwork
asheppardwork
Old Hand
Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)

Group: General Forum Members
Points: 307 Visits: 164
I have been getting the following error when moving From SharePoint Integrated mode Back To Native mode with both machines on 2008 R2;

Can anyone tell me why?
I am trying to migrate reports with subscriptions and shared data sources and do not want to do it by hand 1 by 1.

All the research I've found is not precise in telling me if I can or cannot do this. Apparently there isn't many people leaving integrated mode for native mode (yet).

Error:
Reporting Services Scripter Load Log 2.0.0.17

Starting Load at Wed 11/20/2013 16:54:49.45
SCRIPTLOCATION =
REPORTSERVER = http://mysqlserver/ReportServer
BACKUPLOCATION =
SCRIPTLEVEL = SQL2008
TIMEOUT = 60
RS = "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\RS.EXE"

Running script "sharepoint\Reports\sub1\sub2\Daily Orders.rdl.rss"
Unhandled exception:
URI formats are not supported.


Finished Load at Wed 11/20/2013 16:54:53.97

CMD Script:
@echo off
:: ** Script generated by Reporting Services Scripter 2.0.0.17 **
:: ** Created by Jasper Smith (jas@sqldbatips.com) **
:: ** See http://www.sqldbatips.com for help/support **

::Script Variables
SET LOGFILE="RS Scripter Load Log.txt"
SET SCRIPTLOCATION=
SET BACKUPLOCATION=
SET REPORTSERVER=http://mysqlserver/ReportServer
SET RS="C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\RS.EXE"
SET TIMEOUT=60

::Clear Log file
IF EXIST %logfile% DEL %logfile%

::Write Log Header
ECHO Reporting Services Scripter Load Log 2.0.0.17 >>%LOGFILE%
ECHO. >>%LOGFILE%
ECHO Starting Load at %DATE% %TIME% >>%LOGFILE%
ECHO SCRIPTLOCATION = %SCRIPTLOCATION% >>%LOGFILE%
ECHO REPORTSERVER = %REPORTSERVER% >>%LOGFILE%
ECHO BACKUPLOCATION = %BACKUPLOCATION% >>%LOGFILE%
ECHO SCRIPTLEVEL = SQL2008 >>%LOGFILE%
ECHO TIMEOUT = %TIMEOUT% >>%LOGFILE%
ECHO RS = %RS% >>%LOGFILE%
ECHO. >>%LOGFILE%

::Run Scripts

ECHO Running script "%SCRIPTLOCATION%sharepoint\Reports\sub1\sub2\Daily Orders.rdl.rss" >>%LOGFILE%
%RS% -i "%SCRIPTLOCATION%sharepoint\Reports\sub1\sub2\Daily Orders.rdl.rss" -s %REPORTSERVER% -l %TIMEOUT% -v BACKUPLOCATION="%BACKUPLOCATION%" >>%LOGFILE% 2>&1
ECHO. >>%LOGFILE%

ECHO. >>%LOGFILE%
ECHO Finished Load at %DATE% %TIME% >>%LOGFILE%
ECHO. >>%LOGFILE%

RSS Script:
' ** Script generated by Reporting Services Scripter 2.0.0.17 **
' ** Created by Jasper Smith (jas@sqldbatips.com) **
' ** See http://www.sqldbatips.com for help/support **
'
' Report Service : http://mysqlserver/ReportServer/ReportService2005.asmx
' Item Name : Daily Orders
' Item Path : /sharepoint/Reports/sub1/sub2
' Item Type : Report
' Script Date : 11/20/2013 3:46:42 PM
' Generated By : Domain\user



Public Sub Main()
Dim name As String = "Daily%20Orders"
Dim parent As String = "http://sharepointserver/reports/sub1/sub2"
Dim location As String = "http://sharepointserver/reports/sub1/sub2/daily%20orders.rdl"
Dim overwrite As Boolean = True
Dim reportContents As Byte() = Nothing
Dim warnings As Warning() = Nothing
Dim fullpath As String = parent + "/" + name

'Common CatalogItem properties
Dim descprop As New [Property]
descprop.Name = "Description"
descprop.Value = ""
Dim hiddenprop As New [Property]
hiddenprop.Name = "Hidden"
hiddenprop.Value = "False"

Dim props(1) As [Property]
props(0) = descprop
props(1) = hiddenprop

'Read RDL definition from disk
Try
Dim stream As FileStream = File.OpenRead(location)
reportContents = New [Byte](stream.Length-1) {}
stream.Read(reportContents, 0, CInt(stream.Length))
stream.Close()

warnings = RS.CreateReport(name, parent, overwrite, reportContents, props)

If Not (warnings Is Nothing) Then
Dim warning As Warning
For Each warning In warnings
Console.WriteLine(Warning.Message)
Next warning
Else
Console.WriteLine("Report: {0} published successfully with no warnings", name)
End If

'Set report DataSource references
Dim dataSources(0) As DataSource

Dim dsr0 As New DataSourceReference
dsr0.Reference = "/Data Sources/DATA"
Dim ds0 As New DataSource
ds0.Item = CType(dsr0, DataSourceDefinitionOrReference)
ds0.Name="DATA"
dataSources(0) = ds0


RS.SetItemDataSources(fullpath, dataSources)

Console.Writeline("Report DataSources set successfully")



Catch e As IOException
Console.WriteLine(e.Message)
Catch e As SoapException
Console.WriteLine("Error : " + e.Detail.Item("ErrorCode").InnerText + " (" + e.Detail.Item("Message").InnerText + ")")
End Try
End Sub
darkhelmutis
darkhelmutis
SSC-Addicted
SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)

Group: General Forum Members
Points: 467 Visits: 942
Does any if this perhaps apply:

http://technet.microsoft.com/en-us/library/bb326290(v=sql.105).aspx

Specifically the section about URL addressing?

Sorry typing on a phone!
asheppardwork
asheppardwork
Old Hand
Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)

Group: General Forum Members
Points: 307 Visits: 164
Yes, it would appear the URL limitations of SharePoint Integration are the cause of the above error.
I was hoping to jump around it since I can use the paths to navigate to the reports.

Does anyone have a step-by-step instructional on how to move SSRS 2008 R2 reports from SharePoint Integrated mode to SSRS 2008 R2 native mode that will also bring over the subscriptions? I have quite a few reports, each with 30+ subscriptions, and each subscription is unique.
darkhelmutis
darkhelmutis
SSC-Addicted
SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)

Group: General Forum Members
Points: 467 Visits: 942
I haven't had to go from to the other. From MSDN it doesn't look like this possible:

http://technet.microsoft.com/en-us/library/bb326407(v=sql.105).aspx

Anybody have any experience to the contrary?
darkhelmutis
darkhelmutis
SSC-Addicted
SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)SSC-Addicted (467 reputation)

Group: General Forum Members
Points: 467 Visits: 942
I did just happen to notice this:

http://www.sqlservercentral.com/blogs/salvoz-sql/2013/08/07/ssrs-report-actions-url-actions-and-sharepoint/

Doesn't directly apply to moving from Integrated to Native mode, but I wonder if some of the information may be helpful concerning the general format of the Integrated URLs.
avalpandya
avalpandya
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 5
http://web.archive.org/web/20120830141644/http://www.sqldbatips.com/samples/code/RSScripter/RSScripter.zip
EdVassie
EdVassie
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13901 Visits: 3894
This link will ultimately take you to web.archive for the download, but also has links to the SSRS Scripter home page and instructions for use

https://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
avalpandya
avalpandya
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 5
RS Scripter doesn't work on 2012.

However, here is another method via microsoft


https://www.youtube.com/watch?v=ZL8FqCcxBsU
N.B.
N.B.
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 128
avalpandya (7/15/2015)
RS Scripter doesn't work on 2012.

However, here is another method via microsoft


What do you mean? I just migrated over 500 SSRS reports from 2008 R2 to 2012 SP2 using the RS Scripter script and they work just fine.

Only thing we had to do was re-enter the password for the shared credentials on the Datasources, but the instructions inform you of that, and so does the output during the migration.
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