SQL Server 2005 Integration Services (SSIS) provides six package-protection options that pull together the concepts of sensitive-data protection and encryption.

Encrypt all data with password. This option tells SSIS to encrypt the entire package with a password that you provide. The password, which is the encryption key, isn't stored in the package. No user can open the package without the password, and you can't recover a password-encrypted package without the password. This option...