Parameters and Variables in SSIS

[@michaellutz5305]

At 25:29, the connection managers at the Package level do not have all the same properties. They have different GUIDs and are in fact physically separate. This is why SSIS does not treat them the same when one is promoted to the Project Level.

[@michaelaebi1184]

Many Thanks!

[@michaellutz5305]

The information in this video about another Developer being able to determine the Sensitive password values is not entirely correct. This depends on the Protection Level of the project and its packages. We can either encrypt by password or by User Key. If User Key, then only the original person can see the password. If Password, then the Developer must know the Project Password in order to get to the clear text version of any Sensitive values within that Project.

[@stlltrdaddy]

just a bit blurry in full screen.