I am a newbie to SSIS and was hoping someone could help me with an issue that I am working on. We currently use vb script to send out emails. Now we are moving towards SSIS in taking over that procedure. The steps include
1)Execute SQL Script - pulls a list of emails from table
2)Inside a ForEachLoop container, Task Factory Advance Email and SMS Task sends out the emails
3)Update table for each email if email was successful or failed.
I am not familiar with the mechanics, but which SSIS component(s) will help me get the information that the email sent was successful or not? Then I can use that information/value and apply it on TSQL to update the values on the table.
Hope that makes sense