June 3, 2002 at 8:47 am
I have a job that runs on an hourly basis. I would say that 9 out of 10 times it runs fine, but at least 2 to 3 time I get the below failed message. I say failed because when I view the job history and logs I only see the information provided below. You will see that ther is no "Error" message. Has anyone seen this before? What may be causing this.
Thanks for the help, Scott
View History Failed Message =
Executed as user: SECSOURCE\admin_. ...tart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_7 DTSRun OnStart:
DTSStep_DTSDataPumpTask_2 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_7; 1000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_7; 2000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_7; 3000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_7; 4000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_7; 5000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_7; 6000 Rows have been transformed or copied.;...
Process Exit Code 1. The step failed.
June 3, 2002 at 9:24 am
Have you tried turning on the package error logging?
Andy
June 4, 2002 at 1:01 pm
What's the best way to do this?
quote:
Have you tried turning on the package error logging?Andy
http://www.sqlservercentral.com/columnists/awarren/
June 4, 2002 at 1:36 pm
Design the package, click on properties, logging.
Andy
June 4, 2002 at 2:21 pm
I did this yesterday. I looked in the Server Logs, but don't see anything on status of the package?
quote:
Design the package, click on properties, logging.Andy
http://www.sqlservercentral.com/columnists/awarren/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply