How do you Call Parameterized PG Stored Procedure from SSIS Package - SQL Task

More
2 weeks 1 day ago #14532 by Texas Baker
Texas Baker created the topic: How do you Call Parameterized PG Stored Procedure from SSIS Package - SQL Task
How do you Call Parameterized PG Stored Procedure from SSIS Package - SQL Task?

We have packages which execute stored procedures in Postgres 10.X
We are creating a OLEDB Connection and a SQL Script Task with OLE DB Connection.

Our stored procedure looks like as below

DO
$$
BEGIN
Perform spInsertQuery (strQuery => $strInput1, strQuery2 => $strInput2);
END
$$;

We are setting this in SSIS as Direct Input with the above text in query.
We have mapped parameters $strInput1 and $strInput2 to the SSIS USer Variables.

The parameters are not replaced, we have tried with all options like with in quotes and single quotes.
or just using ?,?
Perform spInsertQuery (?,?);

We have to pass named parameters, as we pass part of the input from the SSIS package.
We are hitting this roadblock with PGNP OLED DB driver.
Any pointers on how this can be achieved on SSIS, is greatly appreciated.

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

More
2 weeks 1 day ago #14533 by admin
admin replied the topic: How do you Call Parameterized PG Stored Procedure from SSIS Package - SQL Task
Could you email a test SSIS package, and the CREATE statement for the stored procedure to Support at pgoledb dot com?

We might just send you the latest build, and it will work.

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

Time to create page: 0.068 seconds
Powered by Kunena Forum