I 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 sent
UPDATE 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.