Sending email via Integration services - SQL 2005

I have a customer table with an email id as column .I want to know how to retrieve the email from the table and assign it to a user variable. This variable will be created in the BIDS as user :: variable.
bluepearlAsked:
Who is Participating?
 
pai_prasadConnect With a Mentor Commented:
1. create a query in the Execute SQL Task control Flow.
2 . Include query  
Select emailID
from myTable in it.
3. Declare the variable with the datatype equvi to that of emailId in the table.
4. Dbl click on SQL task, go to ResultSet and assign the value returned by query to the user variable.



0
 
pai_prasadCommented:
y the answer have been graded "C"...
is it inaccurate/incomplete in any sense....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.