Attunity drivers are failing after OS upgrade to 2022

It seems that after upgrading your server OS to 2022, the SSIS packages using Attunity drivers to connect to Oracle are experiencing issues when the password is provided in the connection string environment variable. This could be related to changes in how the operating system handles security and encryption, particularly with sensitive information like passwords.

In SSIS, the default setting for the ProtectionLevel property is EncryptSensitiveWithUserKey, which means sensitive data is encrypted with the user key. If the environment has changed (like an OS upgrade), it may affect how these sensitive properties are decrypted, leading to failures when trying to use them in the connection string directly.

Using a separate password field may bypass this issue, as it allows the package to handle the password in a way that is compatible with the new environment. To resolve this, consider reviewing the ProtectionLevel settings of your SSIS packages and possibly adjusting them to ensure compatibility with the new OS environment.

Additionally, ensure that you have the latest versions of the Attunity connectors installed that are compatible with your SQL Server version and the new OS to avoid any compatibility issues.

References:

• Microsoft Connectors for Oracle and Teradata by Attunity for Integration Services (SSIS)
• Microsoft Connector for Oracle