You develop a package in SQL Server 2008 Integration Services (SSIS).
You need to deploy the package so that it meets the following requirements:
Only authorized users can view and execute the package.
Users will NOT know the database credentials from within the package.
The package should NOT be stored in the MSDB database.
What should you do?
A.
Set the protection level to DontSaveSensitive.
B.
Set the protection level to EncryptSensitiveWithPassword.
C.
Set the protection level to ServerStorage.
D.
Set the protection level to EncryptAIIWithUserKey.
Explanation:
EncryptAllWithUserKey
Encrypts the entire package by using keys based on the user profile. Only the same user
using the same profile can load the package.
Note:
* ProtectionLevel
The protection level of the package. The values are DontSaveSensitive,
EncryptSensitiveWithUserKey, EncryptSensitiveWithPassword, EncryptAllWithPassword,
and
ServerStorage. The default value of this property is EncryptSensitiveWithUserKey.
Incorrect:
Not A: DontSaveSensitive
Sensitive information is not saved in the package. The sensitive information is removed and
replaced with blanks.
Not C: ServerStorage
Encrypts the package within a SQL Server msdb database. This option is supported only
when a package is saved to SQL Server. It is not supported when a package is saved to the
File System.The access control of who can decrypt the package is controlled by SQL Server database
roles.
Not D: EncryptSensitiveWithPassword
Encrypts only sensitive information contained in the package by using a password. DPAPI is
used for this encryption.DTSProtectionLevel Enumeration