There're 2 DTS steps failed from a package log (by SQL server agent output file) as follows

Step DTSStep_DTSExecuteSQLTask_2 (SQLTask) Succeeded [SQLSTATE 01000
Step DTSStep_DTSDataPumpTask_1 (PPP.dbo.ADFRE to PY1.dbo.ADFRE) Failed [SQLSTATE 01000
Step DTSStep_DTSActiveScriptTask_5 (Finished) Succeeded [SQLSTATE 01000
Step DTSStep_DTSActiveScriptTask_4 (Loop Around) Failed [SQLSTATE 01000
Step DTSStep_DTSActiveScriptTask_3 (Begin Loop) Succeeded [SQLSTATE 01000
Step DTSStep_DTSActiveScriptTask_1 (DefineTheGVs) Succeeded [SQLSTATE 01000
Step DTSStep_DTSExecuteSQLTask_1 (Define Table) Succeeded [SQLSTATE 01000

However, I could get a email notification of "Job succeeded" from SQL Server agent as follows

JOB RUN: 'xxx' was run on 2/18/2004
DURATION: 0 hours, 0 minutes, 3 second
STATUS: Succeede
MESSAGES: The job succeeded. The Job was invoked by User sa. The last step to run was step 1 (xxx)

I would like to know what's wrong with the failed steps? Are they false alarms? How to check each steps and record their status to a log correctly?

In the package turn on logging in the package properties and see the errors
returned.
Set the package to "Fail On First Error" as ewll in the package properties



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


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