gcrickman
asked on
Returning Multiple SP outputs back to SSIS
I am calling a SP in a Sql Task like this;
exec DELTEK.GT_STAGING_MAIN_PRO 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.
exec DELTEK.GT_STAGING_MAIN_PRO
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use the SMTP Mail Task .
ASKER
That is what I am using,see picture, but how do I get the output variables into the body of the email. Can I reference them in the body like @[user::varReturnCode].
hi,
yes correct .
1.SELECT MessageSourceType =Variables
2. set the MessageSource from the variable collection like "@[user::varReturnCode]. "
yes correct .
1.SELECT MessageSourceType =Variables
2. set the MessageSource from the variable collection like "@[user::varReturnCode]. "
ASKER
It seems that it only allows me to send one of the variables. Any way you know of to include two of them.
ASKER
@Sthaya,
Is there anyway I can send multiple variables in the body of the email. Right now I onoly see the option to send one.
Is there anyway I can send multiple variables in the body of the email. Right now I onoly see the option to send one.
ASKER
Anymore ideas on this?
ASKER