Hi,

I have created a DTS package with a SQL Task to query a
table that brings back around 100 records. The fields are:
Email address,
Title,
Problem ID.

I created 3 global variable gvEmail, gvTitle and gvProblem.

On the SQL Task, I selected the output Parameters type =
rowvalue. I then mapped the fields to the respective
global variables. When I execute the query, and look at
the values for the global variables, I always see the
first record.

My objective is to send emails to the email addresses that
are in my query. For each record in the query, I want to
send a seperate email (gvEmail), the problem Id
(gvProblem) and the title of the problem (gvTitle).

Can someone please give me some guidance?