I am just not sure how to resolve this issue.
I have a pipeline where it executes a stored procedure (after one step called "Copy data").
When I run the Pipeline, the second step where stored procedure has to do the job does not do the job as expected.
There is no issue with the stored procedure because when I run the stored procedure directly from SQL Server management studio, it works.
This is normal operation, but there is no output (inserting data into table) from Stored Procedure even though it says 'Succeeded':
Bottom option is available in "Activity runs" mode (after job is done):
When I press "Rerun from activity" (on the Stored procedure step), stored procedure does work.
I am not sure where to test or fix on this issue.