To make the connection dynamic, you have to set the "Connection String" property through the Expressions of Connection Manager to a User Defined Variable that will contain the connection string. Then you need to create a Package Configuration (an XML file) which will have the newly added variable and its properties (such as name, value etc.). And when the package runs, the value of variable gets populated with that defined the package configuration file (i.e. XML file).