SSRS report powershell script

• bangsql

  SSC Eights!

  Points: 900

  More actions

  February 1, 2013 at 12:28 pm

  #288415

  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.

• bangsql

  SSC Eights!

  Points: 900

  More actions

  February 4, 2013 at 8:47 am

  #1583997

  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)

• j.hems

  Valued Member

  Points: 55

  More actions

  May 17, 2013 at 3:40 am

  #1616102

  For one, you do not define $dataSourceReferenceType:

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

  What's the output?

  Jeroen