May 23, 2014 at 12:38 pm
Working on a project for a client.
There is functionality all throughout the parent package that will email users based on various events occurring.
I've setup a Gmail account for the client that will be used specifically used for sending these emails through.
I have a variable in SSIS named "vGmailSendingAcct" that has the email address of the Gmail acct.
I have another variable in SSIS named "vGmailSendingAcctPassword" that contains the password needed to enable sending of emails through the email acct. listed in the "vGmailSendingAcct" variable. I obviously don't want to put "TheActualPassword" as a string in the "vGmailSendingAcct" variable, which will actually be found in an XML Configuration File on the production machine in case someone is able to open that in a text editor.
What options do I have for placing an encrypted version of the Gmail acct. password in that variable and having a decryption function run in SSIS to change the password (for example) from "a$g0$b@" to "TheActualPassword"?
Thanks in advance for any suggestions.
May 27, 2014 at 3:04 pm
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy