Link to home
Start Free TrialLog in
Avatar of Elaine_Shi
Elaine_Shi

asked on

DTS package with global variable and send mail task

Hi, all

I am new on creating DTS package.

I have set up connetion, one Execute SQL task which outputs some item descriptions. Now I want to receive an email containing those item description. How would I do? I have set up a global variable for the output, but on the email how can it show up?

appreciate your help

Elaine
SOLUTION
Avatar of nmcdermaid
nmcdermaid

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Elaine_Shi
Elaine_Shi

ASKER

Rommel's suggestion is quite clean and easy to understand, but I just have few problem.  I like your idea.

nmcdermaid's idea is also feasible but I think input into a txt file will be much easier.

Thank you all for your help. I will split the points.
Avatar of Anthony Perkins
>>Rommel's suggestion is quite clean and easy to understand, but I just have few problem. <<
I know what you mean.  The problem is that you need to install and configure SQL Mail, as well as install an Outlook client and setup a profile on the server.  Most shops won't even consider that.

Go with nmcdermaid solution using XPSMTP it is afar simpler solution.