MSDeploy with sql script

Question

I have a deployment package that should run with about 3 different environments.

I want to specify a sql script to run (source) with an environment database (destiniation).

I do not want to specify the connection string in the deployment script because it contains login data in sql.

I would like to be able to read the settings from the destination for the connection string.

Can I mark this parameter, which must be specified when unpacking the deployment package on the server? If so, how do I use the parameter in dest: sql = "connection string"?

Any suggestions would be great.

Answer 1

. , / .