Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2007-08-21 : 13:49:48
|
| Posted - 08/21/2007 : 09:26:00 -------------------------------------------------------------------------------- Hi all,I've a question regarding SSRS 2005. Is there an efficient scripting method to update the connection string for ALL reports that reside on a reporting/web server? "(automating the process, rather than having to change the data source for each individual report that resides on that server)".All suggestions are highly appreciated .Thanks, |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-08-21 : 14:04:39
|
| It is better to setup a small number of shared data sources, instead of a different data source for each report. Much easier to update.CODO ERGO SUM |
 |
|
|
|
|
|
Please advise me ...it's urgent