How to create dynamic connection manager in SSIS

 STEP-1

• Create variables for User Id and Password as shown below.

STEP-2

• On the connection Manager right click and create a New connection
• After Creating, right click on the created connection > Properties
• On Properties click the 3 dots at the right end as shown below.
  
  
  
  
  
  
• Now select the Properties as shown on the left and assign variables to the properties which you created as shown below in the right

• Once the connection is created, you will see the fx before the connection as shown below