in ssis i have script task that, in some situations, raise error (Dts.TaskResult = ScriptResults.Failure). But in sysjobhistory table there is only shor description what happend (Description: The script returned a failure result.). Is there any way that
i can set some system variable to describe what is error so that description ens up in sysjobhistory table?
in the end, i want to look in job activity monitor and see that job is "red" and see the description that couses this failure.
View Complete Post