Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pazzy11
Posting Yak Master
145 Posts |
 Posted - 2008-04-22 : 04:55:34
|
| I have a DTS package that sometimes fails, its strange it succeeds half the time and fails the other half.the annoying thing is the error tells me nothing its :Executed as user: ***. ... DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnProgress: DTSStep_DTSDataPumpTask_4; 4 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4 DTSRun OnFinish: DTSStep_DTSDataPumpTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_5 DTSRun OnProgress: DTSStep_DTSDataPumpTask_5; 0 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_5 DTSRun OnStart: DTSStep_DTSDataPumpTask_6 DTSRun OnProgress: DTSStep_DTSDataPumpTask_6; 0 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_6 DTSRun OnStart: DTSStep_DTSDataPumpTask_7 DTSRun OnError:... Process Exit Code 4. The step failed.Any ideas ?? |
|
|
pazzy11
Posting Yak Master
145 Posts |
Posted - 2008-04-22 : 06:44:01
|
| Or even simpler , What exactly are Process exit codes ? sometimes it will say Process exit code 1, the step failed, the job is setup so 0 is success..but is there a meaning to other codes ? i can't find a reference for each code.. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-22 : 21:45:11
|
| Enable package logging so you can find details in the log. |
|
|
|
|
|
|
DTS package that sometimes fails