In SSIS 2017, how do I change a variable value without using a script task because no coding is allowed.
I have some variables defined:
vEnvironment = "DEV"
vEmailTo = "Mary@company.com"
I want to dynamically change the value of vEmailTo based on vEnvironment.
So if vEnvironment = "PROD" then use the variable vEmailTo with its default value (send to Mary).
If vEnvironment != "PROD" then I want to change the value of vEmailTo =John@mycompany.com.