SSIS - how to send an email from data flow task for not matching data?

• Raja Narendra

  SSC Enthusiast

  Points: 197

  More actions

  June 23, 2009 at 8:44 am

  #131457

  Hi,

  I'm using SSIS - 2005 version. I want to send an email from Data flow task while matching the data from conditional split. For example I'm checking the total amount balance for each day which should not exceed certain value. When this condition is not satisfying, I need to send an email from Data flow task itself.

  Remember that the package will not fail.

  Please help me out.

  Thanks,

  Raja

• edmund chan

  Say Hey Kid

  Points: 689

  More actions

  June 23, 2009 at 3:22 pm

  #1014299

  I would suggest you to save the data into a table first then utilize sp_send_dbmail for notification purpose.

  Ed