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.
