I have an SSIS package which uses SQL Server Configurations. This uses an expression-based, project connection manager but is connecting to the instance at development time as opposed to the instance at run time. However the remainder of the package is using the run time version of the connection manager.
The expression-based values come from environment variables and the correct values are being returned if I look at the overview report of the package execution.
Do SQL Server Configurations accept the expression-based configuration managers or are they fixed at design time? If the latter, is there a way to make these dynamic?