- Thank you received: 0
Passing variable to PostgreSQL function from SSIS OLE DB Command
- Jose Sebastian
- Topic Author
- Offline
- User
-
Less
More
4 years 6 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:
It works with static values like
But not able to parametrise it like
I am using PGNP OLEDB Providers for PostgreSQL.
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.
4 years 6 months ago #14472
by admin
Replied by admin on 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
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.149 seconds