This option encrypts the whole package using the password.
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 EncryptAllWithPassword 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.
All information is encrypted with the password.
