Post reply

send mail task

  • June 13, 2008 at 5:48 pm

    #124362

    I have 4 data flow and I linked all four of those to send mail task. I want to send mail task if all the data loaded .

    But whats happening if one of the data flow fails its still sending sucessful mail. How can I stop doing that?

    Also how can i attched name of file which was loaded in email.

    Thanks

  • June 16, 2008 at 3:57 am

    #829102

    hey,

    Send mail is really easy conceptually.

    First things first, add a precedence constraint and change this to on success. This will ensure that your mail is only sent if the tasks are successful.

    Now for the attachments bit, under the mail section, add your attachment.

    The coolest thing about the send mail is that if you combine it with SSIS Configurations, it becomes mighty portable...

    ~PD

  • June 17, 2008 at 7:22 am

    #829765

    Only on success add the send email task

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

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