Page 1 of 1

Write Exceptions to File

Posted: Tue Feb 18, 2014 1:19 pm
by iq_etl
I've got a sequence with an Exception Handler in it that then leads to a Notification Activity. There's not a lot of data to go on with from just the Notification Activity, so serves more as a 'heads-up' only.

However, I'd like it to be more useful than that.

I'd like the Exception Handler to write the $ErrSource, $ErrNumber, and $ErrMessage to a sequential file, and this file would then be attached to the email send via the Notification Activity.

The above seems like a pretty straightforward way to quickly get access to why the exception was triggered.

So...how to do it?

Between the Exception Handler and Notification Activity would I include a Job Activity that goes to a job which writes the $Err* values to a Sequential File? How do I capture those values in the first place?

Thanks!

Posted: Tue Feb 18, 2014 2:05 pm
by ray.wurlod
Expose job parameters to receive these values. In the Job activity set the values for those parameters using the activity variables from the Exception Handler.