Hi All

When I execute a DTS Package interactively I can view the
Status of each step through the Execution Progress screen
that contains the execution progress status bar. ie.
Step 1 - Complete; Step 2 - Not Run; Step 3 - Error
Occurred etc. When I click on a step that has failed I
receive an "nice" error message. How do I go about
capturing this error message that is displayed when the
status is clicked on so that the error message can be
written to a file when the package is executed as a Job
Step. I have tried logging the package using the error
log but the error displayed in the log file does not
contain the "nice" message that is displayed when the
step status is selected interactively. Any assistance
would be appreciated.

Thanks

The "Nice" error message should still be there. The package level logging
can be seen sometines as a summary but for a DataPump task it has it's own
logging ability and is pretty good.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Gary" <anonymous (AT) discussions (DOT) microsoft.com> wrote