FIX: "'Salt' attribute for OraPassword is missing" error in SSIS in SQL Server 2012 or 2014

Symptoms

Consider the following scenario: 
  • You create a Microsoft SQL Server 2012 or 2014 Integration Services (SSIS 2012/2014) package by using SQL Server Data Tools (SSDT).
  • You create a connection manager by using the Microsoft Connector for Oracle by Attunity.
  • You set the ProtectionLevel property of the project to EncryptSensitiveWithPassword.
In this scenario, when you build the SSIS package, you receive an error message that resembles the following:
'Salt' attribute for OraPassword is missing in the project manifest.

Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.
Properties

Article ID: 3156452 - Last Review: Oct 18, 2016 - Revision: 1

Feedback