Encrypting All the Information in the Package

Two options are available for encrypting the whole package: EncryptAllWithUserKey and EncryptAllWithPassword. These use a user key or a package password, respectively, to encrypt all the information in a package.

Using the EncryptAllWithUserKey option, you encrypt all the information in the package using a user key. As the user key is generated based on the user profile, only the user who created or exported the package using the same profile can open the package.

Using the EncryptAllWithPassword option, you encrypt all the information in the package using a password specified in the PackagePassword property. You can use this option to secure the contents of the package yet allow the development team ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.