• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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.
 1 2
0
gcrickman
Asked:
gcrickman
  • 5
  • 3
1 Solution
 
SThayaCommented:
Hi,

  try the below code .
@[User::varReturnCode]=="FAILED"
still you are facing the same issue . please send me the SP code
0
 
gcrickmanVP Information Technology ServicesAuthor Commented:
This worked for the validation of the expression. But how do I send the two variables within the  email notification.
0
 
SThayaCommented:
You can use the SMTP Mail Task .
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
gcrickmanVP Information Technology ServicesAuthor Commented:
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].
0
 
SThayaCommented:
hi,

  yes correct .

   1.SELECT    MessageSourceType =Variables
   2. set the   MessageSource from the variable collection like "@[user::varReturnCode]. "
0
 
gcrickmanVP Information Technology ServicesAuthor Commented:
It seems that it only allows me to send one of the variables. Any way you know of to include two of them.
0
 
gcrickmanVP Information Technology ServicesAuthor Commented:
@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.
0
 
gcrickmanVP Information Technology ServicesAuthor Commented:
Anymore ideas on this?
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now