SSIS: Configure a password property to use a User variable
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 instance if you set the password property to %User::MyVariable%, at runtime the SSIS task will use the value held in the MyVariable variable as the value for the password property.
We appreciate your feedback. If you have any questions, comments, or suggestions about this article please contact our support team at firstname.lastname@example.org.