So I've started setting up RS Scripter to do my team's SSRS deployments from Dev -> QA -> Production. However, I've now noticed after deploying reports from one environment to another, all of the passwords have been lost on my embedded datasources. We have many reports and having to type in the credentials on every deployment is going to be painful. Is there any way around this?
A quick note. My connection strings are dynamic so I cannot use shared datasources. They must be embedded.
Thank you for any advice you can give.