InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:12:46 GMT20http://www.sqlservercentral.com/Forums/Topic1414803-1351-1.aspxFor one, you do not define $dataSourceReferenceType:$dataSourceReferenceType=New-Object "$ns.DataSourceReference"What's the output?JeroenFri, 17 May 2013 03:40:30 GMTj.hemshttp://www.sqlservercentral.com/Forums/Topic1414803-1351-1.aspxCan 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)Mon, 04 Feb 2013 08:47:17 GMTbangsqlhttp://www.sqlservercentral.com/Forums/Topic1414803-1351-1.aspxI have SSRS 2008R2 reporting having 3 data sources.Say reportname = \Marketing\Test.rdlDataSource name = \Shared DataSources\Data1 , 2 ,3Now 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.Fri, 01 Feb 2013 12:28:07 GMTbangsql