title: How do I use the SSIS configuration manager? i.e. to easily set Dev or Test or Prod configurations to a process?
body: <p>Other integration tools allow setup of connections for various level of deployment. i.e. Dev, Test, Prod and it is just a matter of switching (choosing) dev or test or prod and the connections are all as per those settings ..  e.g. Talend integration tool has context variables and context environments ..</p>
  
  <p><a href="https://i.stack.imgur.com/efj8p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/efj8p.png" alt="enter image description here"></a> </p>
  
  <p>The Talend context environment can be set post deployment even in TAC.</p>
  
  <p>Assume SSIS and SSMS have same capabilities as this. (I just need to learn how to use).</p>
  
  <p>Any pointers to doco/courses/youtube where I can learn about using this in SSIS ?</p>
  
  <p>I can see the SSIS "Solution Configurations" drop down offering me Dev, Test, Prod ... 
  I can see the "Configuration Manager..." option and have a whole lot of content in this dialog .. 
  But I'm not sure how this is used/setup here in SSIS ?</p>
  
  <p><a href="https://i.stack.imgur.com/uf7Ds.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uf7Ds.png" alt="enter image description here"></a></p>
  
  <p>I have tried to create a Prod "New Project Configuration" for the current project but I get message "This configuration could not be created because a solution configuration of the same name already exists."
  I will check to see if any MS doco on this.</p>
  
  <p><a href="https://i.stack.imgur.com/jpNEj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jpNEj.png" alt="enter image description here"></a></p>