Passing variable to PostgreSQL function from SSIS OLE DB Command

  • Jose Sebastian
  • Topic Author
  • Offline
  • User
  • User
More
5 years 7 months ago #14471 by Jose Sebastian
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:
Code:
UpdateZone(ZoneId integer,ZoneName varchar(50)) returns void

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

But not able to parametrise it like
Code:
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
5 years 7 months ago #14472 by admin
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.154 seconds
Powered by Kunena Forum