Post reply

SSIS Email Genaration with Error message in the Body

  • October 22, 2010 at 11:58 am

    #228229

    Hi,

    In brief, I am running around 7 tasks in SSIS Package. I have give common error email notification with just failed as message..

    Any one can help me how to Capture error message into Email body..

    I am very poor( Almost nill) in vb scripting...

    Can you any body suggest me how to do it..

    Regards

    Ram..

    🙂

  • October 22, 2010 at 12:05 pm

    #1241108

    I use an On Error event handler at the package level to append the System::ErrorDescription variable to my own variable for any error that occurs. I then include the content of my variable in the email message.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 22, 2010 at 12:09 pm

    #1241110

    Thanks Alvin,

    It would be helpful for me if you can provide good link for me to study and research on this.

    Ram..

    🙂

  • October 22, 2010 at 12:16 pm

    #1241113

    Sorry, but I do not have any good links for you. I figured out how to do this by myself. It's not that hard.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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