Automatically connect to new data source in SSRS 2008

• rozanjos

  SSC Veteran

  Points: 269

  More actions

  April 14, 2013 at 2:10 pm

  #292328

  Hi,

  I have lots of reports created using the version SSRS 2008 and the Data Source is ORACLE. All the reports are connected to one DB server. But soon db sever is going to change. So whenever there is a change in the db server I want all the reports to be automatically connected to that new server. So I don't need to individually change the data source of all the reports manually.

  Please help me to find a solution to this problem.

  Thanks in advance!