Send a Mail with Attachment with Script Task

• nero.ch

  Newbie

  Points: 5

  More actions

  June 25, 2009 at 12:54 am

  #133445

  hey

  is it possible to send a mail with multiple attachments with the script task?

  thanks for any help

• OriginalWHY

  Mr or Mrs. 500

  Points: 524

  More actions

  June 25, 2009 at 5:37 am

  #1015219

  Hi

  Dabase mail need to be configured

  You can use Query after db mail configured

  EXEC msdb.dbo.sp_send_dbmail

  @profile_name = 'MAIL', --DB mail Profile

  @recipients -- = 'abc@abc.co.za',

  @body = 'Info',

  @subject = 'SUbject',

  @file_attachments = 'c:\abc.doc;c:\babc.doc'

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  June 25, 2009 at 7:51 am

  #1015313

  nero.ch (6/25/2009)

  ---

  hey

  is it possible to send a mail with multiple attachments with the script task?

  thanks for any help

  Yes, it is possible. Check MailMessage class and Attachments property. Also check here for ideas.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/