How to send mails to Multiple mailids selected dynamically using send mail task in SSIS?

Question

Hi , I am using SSIS 2005 for creating package. I am having a requirement where i need to get data from databse store it in adestination and retrieve only email ids from that store nad send mails to each and evry id that i have received. I am using Expressions in the send mail task where i am getting the mail ids from the record set store.But the task is unable to retrive all those records and showing an error as 'No receipents in the Send mail task'.

please suggest. Thanks in advance...

Answer 1

I resolved the issue by setting the Poperty of the send mail task 'DelayValidation to 'True'