What should you do?

You have designed and saved 35 Microsoft SQL Server 2005 Integration Services (SSIS) packages.
The packages are stored in a single folder on the network. All the team members can view the packages but not the property values. You need to ensure that the property values are password protected. What should you do?

You have designed and saved 35 Microsoft SQL Server 2005 Integration Services (SSIS) packages.
The packages are stored in a single folder on the network. All the team members can view the packages but not the property values. You need to ensure that the property values are password protected. What should you do?

A.
Use a batch file that runs the dtutil program to set the PackageProtectionLevel property to EncryptSensitiveWithPassword on each of the SSIS packages you have created.

B.
Use a batch file that runs the dtutil program to set the PackageProtectionLevel property to ServerStorage on each of the SSIS packages you have created.

C.
Use the SSIS package designer to set the PackageProtectionLevel property to EncryptAllWithUserKey on each of the previously saved packages.

D.
Use the SSIS package designer to set the PackageProtectionLevel property to EncryptSensitiveWithUserKey on each of the previously saved packages.



Leave a Reply 0

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