I have written a DTS package and will be monitoring it via this table but would like to know the different values for stepexecresult and stepexecstatus in the msdb..sysdtssteplog table. Can anyone advise.

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

from http://www.sqlservercentral.com/forums/printtopic.aspx?forumid=23&messageid=166060
CASE dsl.stepexecstatus
WHEN 1 THEN 'DTSStepExecStat_Waiting'
WHEN 2 THEN 'DTSStepExecStat_InProgress'
WHEN 3 THEN 'DTSStepExecStat_Inactive'
WHEN 4 THEN 'DTSStepExecStat_Completed'
END AS [Step Execute Status]
, CASE dsl.stepexecresult
WHEN 0 THEN 'DTSStepExecResult_Success' --EZ completed
WHEN 1 THEN 'DTSStepExecResult_Failure'

---

open up dts in designer and right click in white space and choose package properties from the resulting menu. Then click on the logging tab and check the log package to sql server option and close dialogue and save package.

When the package runs again (and fails) run this script (got from this site) and change the package name to your package name.