DTS Job Failure. Error 18278

[checkai]

We have a nightly SQL job (DTS) that has been running smoothly. It contains about 8 table truncates, then 8 table copies, next a database Copy, then executes 4 Stored procedures and finally does another Database copy. We had 1 field added to a table that gets copied elsewhere. That field was manually added to the other 2 databases that it gets copied to. That's when this SQL job started failing. Here is my properties of the Last steps in the Job History table...Is there any way to see the error that gets generated past this? Ideas?

Step that says 'Retry'
======================

Executed as user: VIRCHOWKRAUSE\cluster. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun 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; ProgressC


Final Step that says 'FAILED'
=============================

Executed as user: VIRCHOWKRAUSE\cluster. ...  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 1.  The step failed.

Windows Application Event Log.

18278: Database log truncated: Database: StarReporting.

any clues??? Thanks!

 

[JayKusch]

PLEASE DO NOT CROSS POST!!!

You have already started a post on this issue ... thread962-843990

Thanks

J. Kusch