If we are using this option, it will encrypt the sensitive information using the password, and save that encrypted information in the package. Password for sensitive data is provided by using the Package Password property.
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 EncryptSensitiveWithPassword on the package.
Click on the package property
Now set the password.
We need to set the package level
After that, we need to set the protection level on the package level.
And click on the properties
Click ok.
See the code of this package
Sensitive data (password) stored in the package and it is encrypted.
Now I am taking destination flat file.
Now the package is ready to run.
Running the package.
Package executed successfully.
Now I am closing the package.
When we will open this, it will ask the password. Any user can open this package by providing the password.
See below.
Here I am providing the password and clicking ok.
