Edit Question - KnowledgeHub

Title Body

I'm trying to ahange data sources of multiple SSRS Report with Powershell to one shared data source on my reporting server. Here my code: cls; $reportserver = "myServer"; $url = "http://$($reportserver)/reportserver/reportservice2005.asmx?WSDL";"; $ssrs = New-WebServiceProxy -uri $url -UseDefaultCredential -Namespace "ReportingWebService"; [ReportingWebService.DataSource[]] $myDataSource = new-object ReportingWebService.DataSource $myDataSource[0].Name = "myDS""; $myDataSource[0].Item = New-Object ReportingWebService.DataSourceReference $myDataSource[0].Item.Reference = "/Data Sources/MyDS" $reports = $ssrs.ListChildren('/DH', $false) $reports | ForEach-Object { $reportPath = $_.path Write-Host "Report: " $reportPath $dataSources = $ssrs.GetItemDataSources($reportPath) $dataSources | ForEach-Object { Write-Host "Old source: $($_.Name), $($_.Item.ConnectString)" $ssrs.SetItemDataSources($reportPath, $myDataSource) Write-Host "New source: $($_.Name), $($_.Item.ConnectString)" } Write-Host "------------------------" } But I'm getting the following error when calling "SetItemDataSources"-method: ***Argument "1" having the value "ReportingWebService.DataSource[]" of "SetItemDataSources" can not be converted to type "ReportingWebService.DataSource[]".*** The question is: What's wrong? The types are the SAME!

Tags (comma-separated) Cancel