EncryptAllWithPassword protection level in SSIS

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.