I'm looking at using a DevOps Pipeline to deploy an SSRS solution from a Repository to different environments. I've seen this on the marketplace. https://marketplace.visualstudio.com/items?itemName=mmajcica.deploy-ssrs Is there a way after getting connection strings for say Dev, Test & Prod I could push them into the config file?
Thanks, Dan
You can try to create a variable group and Link secrets from an Azure key vault, you can store your Data Source Connection with different variables (Dev, Test & Prod ), then you can use the variables to replace the Data Source connection string in the config file using Replace Tokens or Replace Text in Source Files extension.
Just try to install the extensions, then add the task to replace the Data Source Connection from the config file using the specific variable before the Deploy MS SQL SSRS Report task.
For example, add 3 stages to deploy to Dev, Test & Prod environments separately. Every time it will load the default config file, and replace the string to it for further using.
