SSRS report powershell script

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » Powershell » SSRS report powershell script

SSRS report powershell script

Rate Topic

Display Mode

Topic Options

Author

Message

bangsql

Posted Friday, February 01, 2013 12:28 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 27, Visits: 367

I have SSRS 2008R2 reporting having 3 data sources.

Say reportname = \Marketing\Test.rdl

DataSource name = \Shared DataSources\Data1 , 2 ,3

Now when deploy the report using reports manager upload functionality , after deployment it looses all three connection reference.

is there any powershell script to set again correct datasource for this 1 report.

Post #1414803

bangsql

Posted Monday, February 04, 2013 8:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 27, Visits: 367

Can anyone tell what's missing in this?

-------------------------------------------------------

$reportServerName = "SSRS01"
$currentPath ="/Marketing/test1"

$reportServerUri = "http://{0}/ReportServer/ReportService2010.asmx" -f $reportServerName
$proxy = New-WebServiceProxy -Uri $reportServerUri -Namespace SSRS.ReportingService2010 -UseDefaultCredential

$type =$proxy.GetType().Namespace

$dataSourceArrayType = ($type + '.DataSource[]')
$dataSourceType = ($type +'.DataSource')

$numDataSources = 3

$dataSourceArray = New-Object ($dataSourceArrayType)$numDataSources

$dataSourceArray[0] = New-Object ($dataSourceType)
$dataSourceArray[0].Name = "Marketing1"
$dataSourceArray[0].Item = New-Object ($dataSourceReferenceType)
$dataSourceArray[0].Item.Reference = "/Shared Data Sources/Marketing1"

$dataSourceArray[1] = New-Object ($dataSourceType)
$dataSourceArray[1].Name = "Marketing2"
$dataSourceArray[1].Item = New-Object ($dataSourceReferenceType)
$dataSourceArray[1].Item.Reference = "/Shared Data Sources/Marketing2"

$dataSourceArray[2] = New-Object ($dataSourceType)
$dataSourceArray[2].Name = "Marketing3"
$dataSourceArray[2].Item = New-Object ($dataSourceReferenceType)
$dataSourceArray[2].Item.Reference = "/Shared Data Sources/Marketing3"

$proxy.setItemDataSources ($currentPath,$DataSourceArray)

Post #1415350

j.hems

Posted Friday, May 17, 2013 3:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:38 AM
Points: 1, Visits: 2

For one, you do not define $dataSourceReferenceType:

$dataSourceReferenceType=New-Object "$ns.DataSourceReference"

What's the output?

Jeroen

Post #1453913

« Prev Topic | Next Topic »

Permissions