I have a stored procedure that I need to execute to get an auto incremented value from the SQL database.
The stored Procedure does not have any parameters passed to it, but returns a single value.
I figured I cannot access the output from Execute SQL script step.
I tried running the Stored Procedure and it keeps giving me 'Could Not find Stored Procedure' Error.
What could be the issue.
Thanks in advance