Need more descriptive error message

Hi,

Currently I have an event handler on my package that executes a script task on the "OnError" event (at the package level).

One of the error handler's script task's job is to capture the "System::ErrorDescription" and store it to a user variable which is then later sent in an email. That part works fine.

But what I am wondering is, there a way to make the error description more descriptive? I would like to send a custom error message from one of the tasks in my package, if possible. The task is a script task.

Currently, the "System::ErrorDescription" is just:

The Script returned a failure result.

Which isn't too terribly descriptive! But this is the default error description.

Is there something I can do to change the default error message for my script task? Is there a way I can set the "System::ErrorDescription" on this script task, perhaps? Or is there another way?

Thanks much

Usually when there is an error, there will be some more additional errors raised by the SSIS. Hence Error Description will always have the last error message only, unless you handle all the previous ones.

jwelch has explained it more clearly here:

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/05/handling-multiple-errors-in-ssis.aspx

Thanks

|||

I already have this code in place.

My question is how to add my own custom error message. But I think I have a solution.

I can create a user variable, populate it in the event of an error, and append it to my emailMessage variable.