Which three steps should you perform in sequence?

You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a
production server. The package contains sensitive information secured by using the
EncryptSensitiveWithUserKey package protection level. You are preparing the package for deployment by the
production operations team. You need to ensure thatthe production operations team can open and execute the
package without re-entering the sensitive information. Which three steps should you perform in sequence? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order.)

You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a
production server. The package contains sensitive information secured by using the
EncryptSensitiveWithUserKey package protection level. You are preparing the package for deployment by the
production operations team. You need to ensure thatthe production operations team can open and execute the
package without re-entering the sensitive information. Which three steps should you perform in sequence? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order.)

Answer:

Explanation:

Show Hint

Leave a Reply 1

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

Howie

Howie

1. Open the package in SQL Server Data Tools.

2. Click the design surface of the Control Flow designer.

3. In the Properties window, change the ProtectionLevel property to EncryptSensitiveWithPassword and enter the PackagePassword.

Reply