SSIS package configuration connecting to design-time instance

  • 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?

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply