Post reply

Send mail task

  • June 29, 2009 at 4:44 am

    #206100

    Hi all,

    I have configured the send mail task (triggered on error) for my packages but the problem is that if there are multiple error messages I would recieve multiple emails. Can any one please tell me how to make it work in a way that it only send one email containing all the messages?

    Thanks.

  • July 1, 2009 at 7:10 pm

    #1018841

    Could you explain the layout of your package better or perhaps a screen shot to give us a better idea.

    I'm working kind of blind here but you might be able to create a variable fill it with a blank (not NULL) string and then use a SQLtask or a Script task to concatenate the error messages together and then at the end do a test to see if the variable is blank and if not email its contents..

    CEWII

  • July 2, 2009 at 10:57 am

    #1019335

    Hi,

    It seems to be a right idea but I am not realy sure how would I concatenate the error message using the script or sqltask ? It will be great if there is any tutorial or mayb if you give a bit of step break down mayb just hints (to save ur time)

    Thanks,

    Sameer.

  • July 2, 2009 at 10:58 am

    #1019336

    Hi,

    It seems to be a right idea but I am not realy sure how would I concatenate the error message using the script or sqltask ? It will be great if there is any tutorial or mayb if you give a bit of step break down mayb just hints (to save ur time)

    Thanks,

    Sameer.

  • July 7, 2009 at 6:11 pm

    #1021410

    I think you could accomplish it easiest with the Script task. You feed the variable in, regardless of the variable contents you add the message to it. and move on. If you know how to use script tasks in the control flow I'm sure you can make this work.

    Unfortunately I don't have a good tutorial for it..

    CEWII

Viewing 5 posts - 1 through 4 (of 4 total)

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