May 25, 2023 at 10:18 am
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?
May 26, 2023 at 11:10 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy