SSIS and email

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  August 20, 2008 at 9:12 pm

  #127119

  i am using SSIS to select a file from a server and email that to selected receipient.

  Say the filename are

  1. Appln1.txt then email should go to appln1@test.com

  2. Appln2.txt then email should go to appln2@test.com

  3. Appln3.txt then email should go to appln13test.com

  How do i achieve this thru SSIS? Please let me know

• Loner

  SSC-Insane

  Points: 21279

  More actions

  August 28, 2008 at 12:18 pm

  #864621

  There is a SendMailTask in the Control Flow Tab but you make sure the Database mail is working.