CODEWITHSUNDEEP
sql-serverssissql-server-2012
Krishna
Krishna

Reputation: 85

SSIS connection manager Expression not updated with the modified values

Connection manager in my SSIS package uses expression for connection string. Expression contains user id and password variables. My user id and password has encrypted values taken from config.In design time to avoid connection error I directly edited password variable's value with the actual password(decrypted)

The problem is the connection string is not updating with the modified variable values. Any idea on this?

Upvotes: 0

Views: 1870

Answers (1)

SinisterPenguin
SinisterPenguin

Reputation: 1618

It may be a package configuration issue.

If you have a Package configuration set it will always use it regardless of whether you overwrite manually, as soon as you run the package it will use the configuration.

You will see an informational message in the "Error list" window if a configuration is being used.

If this is the case you will need to either disable the config or update it.

Upvotes: 1

Related Questions