I am calling a SP in a Sql Task like this;
C 0,'NORMAL','N', @P_RETURN_CD OUTPUT, @P_RETURN_DESC OUTPUT
You can see by the attachment that I have created two variables to hold these return values.
I am then trying to create a precedent expression to send an email notifcation when the ReturnCode is "FAILED" then send the ReturnCode as well as ReturnDesc.
Both variables and output from SP is Varchar 30.