Hi,

I have migrated several DTS packages to SSIS (re-written) and I'm trying to
improve the logging. I currently have a execute sql task which logs to a
database table on the OnTaskFailed event, I can get the name of the task
which has failed using expressions and 'System:SourceName' but is there any
way to get a detailed error message to dianose why the task failed?

I've noticed that SSIS seems to provide less information in this respect
than DTS even when executing interactively, for example if an Execute SQL
tasks uses a user defined function and it doesn't exist or permissions are
not granted you would get a message stating that in DTS wherewas SSIS seems
just to say task failed...perhaps this is my ignorance and there is a way to
see this....

Any help in this area would be appreciated.

Hello Neil,

Have you looked at

On Error event handlers?

These give you an error code + description




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan,

I've tried both onTaskFailed & OnError an neither give the required level of
detail. The task that is failing is a sendmail task, the OnTaskFailed at
least reports this but the OnError provides neither a useful code or
description (blank in this case). I've seen examples of error handling where
a script task is used to force an error to check its working etc but I want
to be confident that all tasks that could possibly fail will give a
reasonable level of detail to fix the problem.

Any other suggestions?

Thanks
N

"Allan Mitchell" wrote: