I have yet to find how to change the connection string in a Reporting Services data source and thought that I would ask how here.
I have an environment where the report definitions and data sources will be developed against one SQL server, deployed through a source version control tool, ChangeMan, to a test RS server, and then after testing promoted to a production RS server. At that point, the data source connection string needs to be modified to reference a production SQL server.
SSIS allows the developer to build a package with a configuration file that can be modified through the deployment utility. Is there anything like that with RS?
I know about the "standard" deployment function, build the report in BIDS and deploy it to the RS server.
I don't have the environment that will allow the developer to build and deploy to a production server, and it is frowned on to allow them to deploy directly to the test environment.
Does anyone have any suggestions on how to address this?