DTS Job Fails But Not Sure Why

[JohnBates]

hi all,
SQL Server 2000
When we run the JOB which just executes the package, the job fails with the following error:

Executed as user: WSPIFFDATA1\rmr0. ...tart: Create Table tmpJournal_Detail Step DTSRun OnFinish: Create Table tmpJournal_Detail Step DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress: ... Process Exit Code 1. The step failed.


But when we execute the DTS package via Enterprise Manager, the execution completes successfully.

WHat does Process Exit Code 1 refer to? All steps/tasks in the package appear to have executed successfully.

Thanks John

 

[mrdenny]

Exit code 1 is a failure.

In the properties of the DTS package turn on the package logging then have the package run again. This will give you better logging of what it's doing, and why it's failing.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JohnBates]

yeah. It gave a message of 'MAPI Login failed'.
We have resolved the problem.
Thanks.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com