CODEWITHSUNDEEP
stored-proceduresamazon-redshiftconnection-stringgoogle-assistant-sdkexecute-sql-task
Saranya
Saranya

Reputation: 1

HI, I am not able to call redshift stored procedure in SSIS ExecuteSqltask

I am getting this error, while calling stored procedure of Redshift. we are using oledb connection

Error: 0xC002F210 at Execute SQL Task 1, Execute SQL Task: Executing the query "call dev.proc_test" failed with the following error: "Undefined procedure proc_test". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Task failed: Execute SQL Task 1

I have set result set as none because my procedure is not returning any value. I have called the procedure with db name. In my Redshift db procedure is saving under functions tab. Is that the reason for my error? why my procedure is saving under the functions, how to rectify this

Upvotes: 0

Views: 105

Answers (1)

Saranya
Saranya

Reputation: 1

I have called the procedure with the DB name ,It is working fine [image] [1]: https://i.sstatic.net/2hWpl.png

Upvotes: 0

Related Questions