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_PROC 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.

ASKER CERTIFIED SOLUTION

SThaya

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gcrickman

ASKER

This worked for the validation of the expression. But how do I send the two variables within the email notification.

SThaya

You can use the SMTP Mail Task .

gcrickman

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].

SThaya

hi,

yes correct .

1.SELECT MessageSourceType =Variables
2. set the MessageSource from the variable collection like "@[user::varReturnCode]. "

gcrickman

ASKER

It seems that it only allows me to send one of the variables. Any way you know of to include two of them.

gcrickman

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.

gcrickman

ASKER

Anymore ideas on this?