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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>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.
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.
ASKER
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.