Loop through rowset and send email

[JanS]

Hi,

I am trying to write a DTS package to loop through a rowset of email addresses (created by a Execute SQL Task) and send an email to each address in the rowset.

This is to notify a number of people of certain data status.

I can successfully loop through the rowset via an activex task and alter the properties of the send mail task but it only sends mal once the loop has completed ie to the last email address only.

How can I get the job to send an email on each iteration of the loop?

Please let me know if you need further detail/explanation.

Cheers
Jan

 

[JanS]

NOt to worry - Ive worked it out by creating the sendmailtasks at runtime.

Thanks
Jan