Using Microsoft’s SQL Server Data Tools ( SSDT).
Trying to deploy a project …
but, running into the errors pasted below
Failed to deploy the project. Build errors were encountered. For more information, see the Output Window.
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
- At the Project Level
- Note and Adjust the Project’s ProtectionLevel to suit your needs
- Ours is “DontSaveSensitive”
- For each Package
- Access the Package’s Property Window
- Align the package’s ProtectionLevel to match the Project’s Protection Level
Project Protection Level
Screen – Original
Original Project Protection level is “Encrypt sensitive data with user key“.
Screen – Revised
Revised Project ProtectionLevel is “DontSaveSensitive“.
Project ProtectionLevel’s Changed, but Package ProtectionLevel left as is
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.