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. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at email@example.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.
Knowledge is the power, Dont miss any paper, Subscribe to us