SSIS package configuration connecting to design-time instance

• Pete Bishop

  Default port

  Points: 1485

  More actions

  May 25, 2023 at 10:18 am

  #4197228

  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?

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 26, 2023 at 11:10 am

  #4198110

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.