Saturday, March 7, 2015

SSIS - Password Protection



PackagePassword --> Package password
ProtectionLevel Property -->
  EncryptSensitiveWithUserKey : Default Type, Encrypt sensitive information like connection string etc with author active directory. One draw back if active directly go away there is no key to unlock the package
  EncryptAllWithUserKey : Same as above, main difference is its encrypt full package not only the sensitive information.
  EncryptSensitiveWithPassword : Encrypt sensitive information with some user defined password
  EncryptAllWithPassword : Encrypt all not only the sensitive information with some user defined password

No comments:

Post a Comment