locked
Multicast Lookup No Match output RRS feed

  • Question

  • I have a requirement where I have to send email if the new record found from lookup and add that new record in the table as well.

    I'm not sure how to send the email under dataflow task. I know we can do that under control flow task.

    For example: source has 11 records and the target has 10, after lookup we got 1 new record. I need to send this record (id, code column from the table) through an email and insert that in the target too. 

    Thanks in advance.

     

    ZK

    Wednesday, February 26, 2014 7:13 PM

Answers

  • You can use Events. Make it hooked to the OnvariableValueChanged as in http://consultingblogs.emc.com/jamiethomson/archive/2006/08/08/SSIS_3A00_-OnVariableValueChanged-event.aspx and the Event editor pane will allow you to add the Mail Task. Oh, and you can put the record into the table in the DFT already.

    Arthur My Blog

    • Marked as answer by SQL_Admirer Thursday, February 27, 2014 8:08 PM
    Wednesday, February 26, 2014 7:49 PM
  • I would have thought best way would be to send a single email outside the DFT, you can store the new values which are added in a separate table and use that instance to send out Emails.

    Abhinav http://bishtabhinav.wordpress.com/

    • Marked as answer by SQL_Admirer Thursday, February 27, 2014 8:08 PM
    Wednesday, February 26, 2014 8:06 PM

All replies

  • You can use Events. Make it hooked to the OnvariableValueChanged as in http://consultingblogs.emc.com/jamiethomson/archive/2006/08/08/SSIS_3A00_-OnVariableValueChanged-event.aspx and the Event editor pane will allow you to add the Mail Task. Oh, and you can put the record into the table in the DFT already.

    Arthur My Blog

    • Marked as answer by SQL_Admirer Thursday, February 27, 2014 8:08 PM
    Wednesday, February 26, 2014 7:49 PM
  • I would have thought best way would be to send a single email outside the DFT, you can store the new values which are added in a separate table and use that instance to send out Emails.

    Abhinav http://bishtabhinav.wordpress.com/

    • Marked as answer by SQL_Admirer Thursday, February 27, 2014 8:08 PM
    Wednesday, February 26, 2014 8:06 PM