October 22, 2014 at 1:46 pm
Hi,
I have an SSIS package built by another developer, and now that I'm running it under my login the passwords won't save. The solution and packages are setup with ProtectionLevel EncryptSensitiveWithUserKey, but how do I get the User Key to reset so I can now save passwords? I can re-enter them, but whenever I enter hte password and test it then click OK it still has the red arrow next to the connection as if there's an error. I can create new connections and those passwords save fine, but with 40-50 items in this package I hate the thought of having to go into each and change the connection.
I tried changing the package and solution to DontSaveSensitive then rebuilding and closing then reopening, but this didn't seem to help. I hoped there was some option to reset the User Key just as if I created the solution. If this option doesn't exist why? Or if so where?
Thanks,
October 23, 2014 at 1:06 am
Don't use SaveSensitiveWithUserKey. Exactly for the reasons you just mentioned.
You cannot reset the user key.
Either change to DontSaveSensitive AND store the usernames and passwords in a configuration, or change to SaveSensitiveWithPassword.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply