If we select this option, it encrypts the sensitive information using the current user settings. Current user means windows user where the package is running.
Let’s see the example
Taking data flow task
Now I am taking OLEDB
Creating a connection
Using SQL server authentication. Click ok.
Select the source
Click ok.
Now we need to set the protection level to EncryptSensitiveWithUserKey on the package.
Click on the package property
Now we need to set protection level on the project level.
See the source code of this package.
Here password is encrypted with the user key. This package is created under the user BAGESH.
Now I am running this package.
The package is executed successfully.
Now I am trying to open this package in another account.
When I am opening this package getting below warning messages.
While I am loading the package getting below error.
See below
Error seems that “Key not valid for use in specified state”
Severity Code Description Project File Line Suppression State
Error Error loading Package.dtsx: Failed to decrypt protected XML node "DTS: Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. I:\SSIS Test\Integration Services Project1\Integration Services Project1\Package.dtsx
