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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
