Hi,
I am executing a stored procedure in PDI job using SQL script step.
The SP fails when i run it directly on SSMS but PDI job is not failing (not able to recognize SQL script is failed instead showing it as success), I have seen this issue before also and knew it could be existing bug.
Is there any resolution or work around?
Kettle version: 8.2
SQL Server: 2016 (or any)
Appreciate your inputs.
Regards,
Ram.
I have tried Job "SQL Script" and transformation "Call DB proc" step both doesn't work.
-Ram