SSIS Combine Error messages in to one message to return?

  • I have a package that on the main package event handler, onError sends an email when an object errors out so that I can see the problem a little easier than running to a log table and retrieving any rows that have an error message.

    But, there are so many items that get triggered when just one object fails that I get 4 emailis for just one object.

    So, I was wondering how I can just append all the errors in a string and at the end of the package return the error or combine the messages for that one object into one message string and email that.

    My thoughts were to create a package level variable 'Message' and somehow append to that

Viewing post 1 (of 1 total)

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