SSIS 2008 R2 - cursor "pgnpcsr1" already exists

[colinx]

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:

Code: Select all

select AddRouteWrapper( ?,?,?,?,?,?,?,?,? )

This is the error I see in SSIS:

Code: Select all

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:

Code: Select all

----------   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

[Moderator]

Could you send the function definition and a sample SSIS package that reproduce the issue to support at pgoledb dot com? Thank you!