RS.SetItemDataSources failing in SSRS 2008

Question

I have a script that I use with rs.exe to import reports and set its data source. This script runs fine in SSRS 2005 but moving over to SSRS 2008 the data source does not get set (sometimes).

If I have a RDL file that is created with a data source named BLAH and I deploy it through rs.exe and call RS.SetItemDataSources with a data source named BLAH then it succeeds and data source is set.

If I call RS.SetItemDataSources with a data source named BLAH2 then I get 'Error : rsDataSourceNotFound (The data source 'BLAH2' cannot be found.)'. BLAH2 does exist and in fact if I edit the RDL file and simply change the data source name to BLAH2, it succeeds.

So from what I gather, the data source you use when deploying must match the data source name you developed with... This was not the case in SSRS 2005. Am I missing something or is there some new way to accomplish this in 2008?

Thanks,
Gork

Answer 1

Hi,

Please refer to this blog http://phil-austin.blogspot.com/2009/02/deploying-reporting-services.html (not microsoft's) about how to set the datasource while deploying reporting service with RS unitily.

Hope this help,

thanks,
Jerry

Answer 2

Hi,

Please refer to this blog http://phil-austin.blogspot.com/2009/02/deploying-reporting-services.html (not microsoft's) about how to set the datasource while deploying reporting service with RS unitily.

Hope this help,

thanks,
Jerry

This doesn't help me at all... you state:

"Therefore you have to work out what data sources that report has a reference to and relate those references to the shared data sources with the same name elsewhere in Reporting Services."

This was not the case in SSRS 2005... You could assign any shared data source regardless of the name the report was built with. It also makes no sense why this would be, seeing as I can navigate through my browser to the reporting server, select the report, click properties, click data source and select the data source I want and it works. I can't do thousands by hand and need to do it with scripting and rs.exe. I am to assume for whatever reason microsoft removed (or forgot to code) this functionality into SSRS 2008's rs.exe...

I really hope that is not the case. If anyone else knows of some other way to accomplish this, I would be very interested.

Thanks,
Gork

Answer 3

Hey Gork,

Have you found any resolution to this? I have pretty much the same issue...