Set New Report Data source reference to use Exisitng Shared Datasource on Report Server- Powershell script
I have a requirement to deploy an Individual SSRS report at a time using - Powershell. But the problem is - I am un able to change its Data source to use Existing Shared datasource that is already available on Report Server. Would someone please help me with the Powershell script to do this. Thanks in advance
October 9th, 2012 7:40am

Hi ajayrenta, To achieve your goal, we need to use both the Reporting Service GetItemDataSources Method and the SetItemDataSources Method. Here is a thread aout the same topic, and the PowerShell script sample will be helpful for you: http://ask.sqlservercentral.com/questions/86369/change-datasource-of-ssrs-report-with-powershell.html Regards, Mike YinMike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2012 3:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics