Which protection level should you use?

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the
package by using your local development environment.
The package is deployed to a production server.
You need to configure the protection level of the package to ensure that only the user who
deployed the package can execute it.
Which protection level should you use?

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the
package by using your local development environment.
The package is deployed to a production server.
You need to configure the protection level of the package to ensure that only the user who
deployed the package can execute it.
Which protection level should you use?

A.
EncryptAllWithPassword

B.
EncryptSensitiveWithPassword

C.
DontSaveSensitive

D.
EncryptAllWithUserKey



Leave a Reply 0

Your email address will not be published. Required fields are marked *