Problems to connect to PostgreSQL in ZappySys SSIS PowerPack

Problem

When trying to connect to PostgreSQL using the ZS PostgreSQL Connection Manager, an error similar to this one is displayed.

Failed to establish a connection to the server. A call to SSPI failed, see inner exception.

Cause

This problem is usually related to an upgrade to the PostgreSQL version. The ZS Connection in version 3.1 or earlier may have this problem.

Solution

Try to install the last version of ZS SSIS PowerPack. We included the fix for this problem on version 4.0.0.11201.