Sql Server Data Tools – Project Deployment – Error – “Project consistency check failed”

Background

Using Microsoft’s SQL Server Data Tools ( SSDT).

Scenario

Trying to deploy a project …

image

but, running into the errors pasted below

Message Box

Image

failedToDeployTheProject_20180207_0826PM

 

Text

Failed to deploy the project.  Build errors were encountered.  For more information, see the Output Window.

Output Window

Image

deployProject_output_20180208_0741AM

 

Text

Error : Project consistency check failed.  The following inconsistencies were detected:

DataRefresh_package1 has a different ProtectionLevel than the project
DataRefresh_package2 has a different ProtectionLevel than the project

 

Remediation

Outline

  1. At the Project Level
    • Note and Adjust the Project’s ProtectionLevel to suit your needs
    • Ours is “DontSaveSensitive
  2. For each Package
    • Access the Package’s Property Window
    • Align the package’s ProtectionLevel to match the Project’s Protection Level

 

ScreenShot

Project

Project Protection Level

Screen – Original

Original Project Protection level is “Encrypt sensitive data with user key“.

Screen – Revised

Revised Project ProtectionLevel is “DontSaveSensitive“.

 

Additional Guidance

Project ProtectionLevel’s Changed, but Package ProtectionLevel left as is

Image

modifyProtectionLevelForEachPackage_20180207_0831PM

 

Text

The ProtectionLevel property of the project has changed.

To build the project, the packages need to have the same protection level as the project.

Open each package and modify the ProtectionLevel property.