InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 02:12:51 GMT20http://www.sqlservercentral.com/Forums/Topic1369041-364-1.aspxI have done something similar to this. Here's how I did.1.) For each loop through your table sending you e-mails. Storing the EmailID you are working with in a user variable (i.e. User::EmailID). 2.) Execute your Send Mail Task3.) Execute SQL TaskIn your Execute SQL Task set the SQLStatment via the expressions tab.Your expression would look something like this. Note I put single quotes around the variable and the date. "UPDATE dbo.table SET DatSent = '" + CSTR(GETDATE()) + "' WHERE EmailID = '" + User::EmailID + "'"There multiple ways to do this I just found this to be easier.Hope this helps,EricWed, 31 Oct 2012 11:12:41 GMTWillyWonkahttp://www.sqlservercentral.com/Forums/Topic1369041-364-1.aspxI am trying to create a package that reads email data from a tables based on if an email has already been sent.The problem I'm having is updating the record after email acknowledgement from the SMTP server.First Issue: I have no idea how to capture that negotiation.Second Issue: Updating the table based on ID as to whether email sentUPDATE tblNotification SET datSent =getdate()WHERE ID = @P2 ---where @P2 is a parameter that comes down and is loaded into the ForEach container (ForEach ADO Enumerator)I'm having trouble finding somewhere a similar solution has been posted.Any ideas welcomed.Thanks,KeithFri, 05 Oct 2012 07:38:50 GMTkeithcorkran