I'm getting the error "cursor "pgnpcsr1" already exists"" whenever I try to execute a postgres stored procedure in SSIS. I'm running the proc from an OLEDB Command transformation. I'm pretty sure the problem is between PGNP and SSIS because I can use PGNP to run the same procedure from a simple C# program.
We downloaded and installed the provider for the first time last week, so I'm pretty sure we've got the most recent version.
This is the stored procedure that I'm trying to run:
select AddRouteWrapper( ?,?,?,?,?,?,?,?,? )
This is the error I see in SSIS:
Error: 0xC0202009 at Data Flow Task, OLE DB Command 1 1 [480]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "PostgreSQL Native Provider" Hresult: 0x80040E14 Description: "ERROR: cursor "pgnpcsr1" already exists
This are the errors I see in the PGNPProfiler:
---------- Client SQL 2013/02/27 11:19:23.443 A2EB3C8A ------------
select * from AddRouteWrapper( ?,?,?,?,?,?,?,?,? )
---------- Error ---------
ERROR: cursor "pgnpcsr1" already exists
I can post more info if necessary. Just let me know what you need.
Can someone point me in the right direction, or just post an example of how to call a stored procedure with parameters from SSIS?
Thanks,
Andrew
