You work as a database administrator at Abc.com. The Abc.com network contains a production database server named ABC-DB01. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package. The SSIS package is stored in a folder on ABC-DB01. All Abc.com users must be able to view the package but must not be able to view the attribute values. You need to ensure that the attribute values are protected by password. What should you do?

1)You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to EncryptSensitiveWithPassword on the SSIS package.

2)You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to SaveSensitive on the SSIS package.

3)You should make use of the SSIS package designer in order to set the PackageProtectionLevel property to EncryptAllWithPassword on the SSIS package.

4)You should make use of the SSIS package designer in order to set the PackageProtectionLevel property to EncryptSensitiveWithUserKey on the SSIS package.

: 299

: 8
PreviousNext

You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to EncryptSensitiveWithPassword on the SSIS package.

Free all India Level Online Ranker test On English

Share the Knowledge

You can help us to improve by giving your valuable suggestions at admin@quhasa.com

By using the service of this site, I agree that I will serve wholeheartedly
and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
I have a firm believe in the notion that knowledge should be open source and
helping the needy and deserving part of society will always be my motto.