Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
162 views
in Technique[技术] by (71.8m points)

SSIS cannot change Project ProtectionLevel to Encrypt sensitive data with password

I am using VS2019 to create SSIS projects. I have tried to update one of my current projects and I have created a new project to try and update the protection level. When trying to update the protection level from EncryptSensitiveWithUserKey to Encrypt sensitive data with password. When trying to do this it allows me to enter a password, but the OK button is disabled. I have tried all kinds of password combos to make sure they are long enough and complex enough. Any ideas how to get by this? enter image description here

question from:https://stackoverflow.com/questions/65852869/ssis-cannot-change-project-protectionlevel-to-encrypt-sensitive-data-with-passwo

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Thanks to vhoang for pushing me just a little further. I had tried to expand the dialog box like I have others in VS for SSIS, but that did not work. What I did do is type in the password in the password box. Then I tabbed to the next box, which is not visible and entered the password again (with faith that I was in the confirm password box). And yep the OK button became available.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...