Hi all,

By using the "/W True" switch to DTSRun, I can get the completion
status of each DTS package run into the event viewer (as per the
manual). Unfortunately, both a successful and a failed DTSRun are
written to the event viewer as "Information" events (i.e. a failed
DTSRun is not written as "Warning" or "Error" event).

The details of a failed DTSRun are available in the description of the
event, but I was hoping to produce a report of failures based on some
sort of filter of the event log (as opposed to having to parse the
description field of all DataTransformationServices events).

Any thoughts about filtering the event viewer entries to quickly find
failed DTSRuns?

Thanks in advance.