How to set a variable in "Attachments" on Send Mail Task? RRS feed

  • 问题

  • I'm using SSIS 2005

    I want to send email by Send Mail Task, and in every email I will post an attachment. I want to set attachment by using a variable, which the value is a full file path.

    2011年6月30日 3:35


  • Click on the expressions tab (on the left of the Send Mail task editor) and expand/click on the ellipsis on the Expressions box on the right. Select the "FileAttachments" property and type in your expression into the Expression box. 

    Good luck


    Qiong Wu - MSFT
    2011年6月30日 6:04