Using dynamic passwords in SSIS

You may need to specify a password dynamically. You can do this by configuring the password property (whether this be Password or Firewall Password) to point to a user variable in the package.

For example, if you set the password property to %User::MyVariable%, the SSIS task will use the value stored in MyVariable at runtime.