Powershell script to do automated deployments for SSRS 2014, error while setting a shared dataset
trying write powershell script automated deployments ssrs 2014. my problem linking report shared dataset. i keep getting error: [error] cannot convert argument "itemreferences", value: "system.object[]", for
[error] "setitemreferences" type "ssrs.reportingservice2010.itemreference[]":
[error] "cannot convert "ssrs.reportingservice2010.itemreference" value of type
[error] "ssrs.reportingservice2010.itemreference" type
[error] "ssrs.reportingservice2010.itemreference"."
[error] @ c:\users\bshaw20\documents\ssrs\powershell deploy\ssrs deploy\ssrs
[error] deploy\prototypev4.ps1:224 char:46
[error] + $rs.setitemreferences($reportpath, @($mydataset))
[error] + ~~~~~~~~~~
[error] + categoryinfo : notspecified: (:) [], methodexception
[error] + fullyqualifiederrorid : methodargumentconversioninvalidcastargument
here script:
function linkshareddatasets {
# list of reports , link them shared datasets
$rs = new-webserviceproxy -uri $reportserveruri -usedefaultcredential -namespace ssrs.reportingservice2010
$rpts = $rs.listchildren($targetfolderrdl, $false)
$newdatasetname = "/interstate apps/commercial/set/setsum"
$myds = "setsum"
$rpts | foreach-object {
$reportpath = $_.path
write-host "report: " $reportpath
$datasets = $rs.getitemreferences($reportpath, "dataset")
$datasets | foreach-object {
if ($_.name -eq $myds) {
$mydataset = new-object -typename ssrs.reportingservice2010.itemreference
$mydataset.name = $myds
$mydataset.reference = $newdatasetname
$myrefs += $mydataset
$rs.setitemreferences($reportpath, @($mydataset))
}
}
}
}
here seemingly article on how acquires types report servies proxy: http://www.sqlmusings.com/2012/02/04/resolving-ssrs-and-powershell-new-webserviceproxy-namespace-issue/
\_(ツ)_/
Windows Server > Windows PowerShell
Comments
Post a Comment