title: SSIS Project Deployment Model: assign sensitive parameter to a project connection string
body: <p>We are using SSIS 2012 Project model and have project connection (manager) for all our packages, we create environment for dev, test and prod and created a variable "Connectionstring" inside each of them, the connection string is SQL Server authentication, so we have set the variable as sensitive to keep password hidden and then we configured the project connection manager to use the environment variable for the connection string. When we run the package we get the below error</p>
  
  <p>"Unable to map an environment variable with the sensitive property set to True, to a parameter with the sensitive property set to False. Ensure that the property settings match"</p>
  
  <p>I was unable to find a location where we can set the sensitive property for project connection manager, FYI when I uncheck the sensitive in the environment variable ,the packages run fine.</p>
  
  <p>Am I missing something? I don't see a place where we can set the expression for project connection manger either, if that was the case at least I could have used the project parameters and set it to sensitive and configure the environment variable  to load into the parameter and in turn use parameter in the expression for project connection string. </p>