Post reply

SSIS Email Task

  • May 18, 2009 at 12:39 pm

    #131192

    I have a table containing the email address of customer along with message i have to send email to every week. I use For Each loop with

    email task to send them email. For only one customer there is an attachment. In future there might be some more. How do check condition and specify attachment in the send email task.

    Thanks in Advance

  • May 19, 2009 at 5:21 pm

    #997324

    vana (5/18/2009)

    I have a table containing the email address of customer along with message i have to send email to every week. I use For Each loop with

    email task to send them email. For only one customer there is an attachment. In future there might be some more. How do check condition and specify attachment in the send email task.

    Thanks in Advance

    You have to create expression in the send mail task to setup FileAttachments property. The expression should use a package variable, which you initialize in a previous step.

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply