SSIS: Configure a password property to use a User variable

You can set the value of a password property to point to a user variable.

Date Entered: 04/08/2008    Last Updated: 04/14/2008

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 entry please contact our support team at