I've been encountering problems with a few of my
scheduled jobs. The jobs always end with "Process Exit
Code 2. The step failed.". When I manually run the DTS
package, it worked just fine with no errors.

What has gone wrong? Please help me to solve the problem.
Thanks a million!!

See if this helps you identify the problem:
http://support.microsoft.com/default...;en-us;q269074
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


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

I've been encountering problems with a few of my
scheduled jobs. The jobs always end with "Process Exit
Code 2. The step failed.". When I manually run the DTS
package, it worked just fine with no errors.

What has gone wrong? Please help me to solve the problem.
Thanks a million!!

Thanks, Vyas.

However, the job actually executes itself for a while
before failing. I've attached the entire error message as
follows :

"Executed as user: WRPBI\SYSTEM. ... OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_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:
DTSStep_DTSDataPumpTask_1; 6000 Rows have been
transformed or copied.; PercentComplete = 0;
ProgressCount = 6000 ... Process Exit Code 2. The
step failed."

Thanks, Vyas.

However, the job actually executes itself for a while
before failing. I've attached the entire error message as
follows :

"Executed as user: WRPBI\SYSTEM. ... OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_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:
DTSStep_DTSDataPumpTask_1; 6000 Rows have been
transformed or copied.; PercentComplete = 0;
ProgressCount = 6000 ... Process Exit Code 2. The
step failed."

That output isn't saying much. Could you enable a log for the DTS package
and capture the exact error?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


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

Thanks, Vyas.

However, the job actually executes itself for a while
before failing. I've attached the entire error message as
follows :

"Executed as user: WRPBI\SYSTEM. ... OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_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:
DTSStep_DTSDataPumpTask_1; 6000 Rows have been
transformed or copied.; PercentComplete = 0;
ProgressCount = 6000 ... Process Exit Code 2. The
step failed."

I've logged the DTS package and error code given was
-2147467259

I realised that this has got to do with the data transfer
from server A to server B in one of the task. I've tested
both the windows and SQL server authentications but
failed. How can we solve it?

Did you ever get an answer to this problem? I'm having a similar issue and
have yet to resolve it.


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

Have the package and the datapumps themselves log to either SQL Server or a
text file. Whilst looking at the job step output is OK it is short.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Deborah Bohannon" <dbohannon (AT) nationalDONOTSENDHEREcareanetwork (DOT) com> wrote
in message news:uqm2lL8gEHA.2952 (AT) TK2MSFTNGP09 (DOT) phx.gbl...