SSIS 2008 R2 - cursor "pgnpcsr1" already exists

  • colinx
  • Topic Author
  • Visitor
  • Visitor
9 years 3 months ago #9896 by 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:
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

Please Log in or Create an account to join the conversation.

More
9 years 3 months ago #9898 by Moderator
Could you send the function definition and a sample SSIS package that reproduce the issue to support at pgoledb dot com? Thank you!

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum