Passing variable to PostgreSQL function from SSIS OLE DB Command

More
1 year 10 months ago #14471 by Jose Sebastian
Jose Sebastian created the topic: Passing variable to PostgreSQL function from SSIS OLE DB Command
I am trying to call a PostgreSQL function and pass value to it using OLE DB Command in SSIS.

My PostgreSQL function signature is as follows:
UpdateZone(ZoneId integer,ZoneName varchar(50)) returns void

It works with static values like
Exec UpdateZone(1,'South')

But not able to parametrise it like
Exec UpdateZone ?,?


Attachment not found



I am using PGNP OLEDB Providers for PostgreSQL.

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

More
1 year 10 months ago #14472 by admin
admin replied the topic: Passing variable to PostgreSQL function from SSIS OLE DB Command
Hello Jose,
thank you for reporting this issue! We were able to reproduce it, and are working on a bugfix. We will send fixed module to you asap.

Kind regards,
Support Team

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

Time to create page: 0.096 seconds
Powered by Kunena Forum