Dynamic Properties Task to send multiple Attachments

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  July 14, 2005 at 1:56 pm

  #69307

  I am using Dynamic Properties Task to assign Global Variables to the File Attachment Property within the Send Mail Task. Is there anyway to send multiple file attachments? I tried setting up multiple file attachments in the Dynamic Properties Task but when I executed the package only one file was actually attached to the email. (We are using SQL Server 2000, SP3.)

  If there is a way I could send multiple links to files using the Message Text Property please let me know. This would allow me to accomplish what I need.

  Thanks in advance, Kevin

   

• Jeff Gray

  SSChampion

  Points: 10667

  More actions

  July 15, 2005 at 7:52 am

  #574814

  According to BOL: "

  Syntax

  [SendMail task object].FileAttachments[= value]

  ...

   Multiple attachment file specifications are separated by semicolons"

   

  I've never tried to send more than one, but it seems that this is the documented way to do it.

  jg

   

• John Cohoon

  Newbie

  Points: 1

  More actions

  December 21, 2005 at 11:49 am

  #610922

  I tried using a semicolon and that does not work.  Anyone know how to add multiple attachments to a MailText?

• Nick Loake

  Newbie

  Points: 4

  More actions

  October 31, 2006 at 10:10 am

  #669020

  In case you're still interested:

  Try something along these lines:

  dim strAttachments

  strAttachments = "C:\File1.txt" + ";" + ""C:\File2.txt"

  oSendMailTask.FileAttachments = strAttachments

  This adds two attachments to your email.