April 15, 2009 at 9:19 am
I am using SSIS to read and write to Oracle. Every few months when the password change regime takes place I have to go into my SSIS packages and manually update the passwords for each OLE DB connection used in data flow tasks.
Is it possible to somehow automate this task in a secure way? I think package configurations may allow me to accomplish that but then how do you encrypt the passwords? since package configuration is just a file??
thanks
April 15, 2009 at 9:38 am
The canonical way would be to put the connection strings to a configuration XML file where you can change it centrally without changing the SSIS packages.
In our project we do not encrypt passwords because the configuration file resides only on the production server which is considered safe against spying. If this is not your case, you would have to have an encryption utility and save the encrypted passwords in the XML file (which in our case is done by the server admins).
MY_JUSTMY2CENTS
Günter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply