Security is the basic need of any application. SSIS Package Protection Level property tells SSIS how to handle sensitive information like password, connection string, stored within SSIS packages. It is used to secure unauthorized access to packages.
We need to configure the protection level.
Ø Project level protection
Ø Package level protection
Project level protection
Right click on the solution
And click on the properties.
Package level protection
Package level protection we will get in the package properties.
Below is the protection level in SSIS.
DontSaveSensitive
DontSaveSensitive – It means this is not going to encrypt anything in the package and so our sensitive information would be blank like password or configuration manager. We would have to then supply our password using SSIS configuration.
EncryptSensitiveWithUserKey
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.
EncryptSensitiveWithPassword
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
EncryptAllWithPassword
This option encrypts the whole package using the password.
EncryptAllWithUserKey
This option uses the current user settings to encrypt the whole package.
