DTS Failed

SQL 2K
We have a job to run a DTS which loads and computes data from a database in
the same server..
This jobs worked till yesterday, failed today with error message
Executed as user: MyDomain\Myuser. ...: DTSStep_DTSExecuteSQLTask_11
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_7
DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_2 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 = ... Process Exit Code 1. The step
failed.
No changes made to server or job..
Looked at the server Event viewer , found nothing ..
Any thoughts '
SI'm guessing this is the output from the job history. The job history ouput
only show part of the DTS log, so you may be missing the critical
information you need to help you debug this problem. Did you output the
entire DTS output to a file with either the advanced tab option when editing
the job step or the dtsrun /L option? If so look at the log file, in there
and you might find additional information. If not modify your job to create
the log file and rerun.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"MS User" <sqlman@.sql.com> wrote in message
news:uHOlG$eMEHA.1188@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a job to run a DTS which loads and computes data from a database
in
> the same server..
> This jobs worked till yesterday, failed today with error message
> Executed as user: MyDomain\Myuser. ...: DTSStep_DTSExecuteSQLTask_11
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_7en">
> DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_2 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 = ... Process Exit Code 1. The step
> failed.
> No changes made to server or job..
> Looked at the server Event viewer , found nothing ..
> Any thoughts '
> S
>