When creating packages, the default security protection level is set as EncryptSensitiveWithUserKey. The user key mentioned is created off of the login of the user who created the project. If a developer other than the one who originally created the project or package opens it, they will receive the following warnings:

Warning loading project_name.dtproj: Warning: Failed to decrypt sensitive data in project with a user key. You may not be the user who encrypted this project, or you are not using the same machine that was used to save the project. If the sensitive data is a parameter value, the value may be required to run the package on the Integration Services server.

Warning loading project_name.dtproj: Warning: Failed to decrypt an encrypted XML node. Verify that the project was created by the same user. Project load will attempt to continue without the encrypted information.

To correct this issue and make the warnings and potential problems go away for other developers, use the following procedure to change the Protection Level from EncryptSensitiveWithUserKey to EncryptAllWithPassword.

• Open Project

Open the project as normal.

• Change Project Properties

Right click on package name. Select Properties.

Click ellipses on Protection level where it says EncryptSensitiveWithUserKey.

On the next screen, select EncryptAllDataWithPassword and click OK.

Enter Password and Retype Password.

Click OK. Click OK again. A prompt tells you that the change has been made. Click OK.

• Change Package Properties

For each package underneath the project, change the security settings to be the same.

Open a package. Click on a non-task area of the package to get to the package properties. Find the Security section.

Change the protection level to Encrypt All with Password.

Click the ellipses next to the PackagePassword property.

In the next screen enter the password.

Click OK.

• Check In Changes

The Project, project parameters and the package has been changed. Check each file in separately or all together from the project level.

• Verify

Open the solution. You should be prompted for a Project Password.

Verify that there are no errors.