We are receiving the following error every time we execute our SSIS process with many different values in the numeric portion of the pgnpcsrNN text of the message. We have this issue since monday this week , but we have the same SSIS process than before.
Making some test to identify the issue, we only have the problema if we inform a query in the origin OLEDB task .... but if we select a table, the SSIS Works.
SQL SERVER:
Microsoft SQL 2014 Server Enterprise (64-bit)
PGNP:
License Type: Server Edition
License Version: 1.4.0.3439
ERROR:
Error: 0xC0202009 en Tarea Flujo de datos, Origen de OLE DB [79]: Código de error SSIS DTS_E_OLEDBERROR. Error de OLE DB. Código de error: 0x80040E21.
Hay un registro OLE DB disponible. Origen: "Intellisoft OLE DB Provider for PostgreSQL" Resultado: 0x80004005 Descripción: "ERROR: cursor "pgnpcsr6" does not exist
".
Thanks
