Hi

(SQL2000)

I'm running a sheduled DTS package, somtimes it works fine, sometimes not
(approx. every 3rd day), receiving this message:

Executed as user: DKILVANT\BPW_USER. ...art:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3
DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259 (80004005)
Error string: [IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0001 - Function
did not complete successfully. Error source: Microsoft OLE DB Provider
for ODBC Drivers Help file: Help context: 0 Error Detail
Records: Error: -2147467259 (80004005); Provider Error: 69399 (10F17)
Error string: Error source: Help file: Help context: 0
DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnFinish:
DTSStep_DTSDataPumpTask_3 DTSRun OnProgress: DTSStep_DTSDataPumpTask_4;
1000 Rows have been transformed or copied.; PercentComplete = 0;
ProgressCount = 1000 DTSRun OnProgress... Process Exit Code 2. The step
failed.


Please let me know if you have any idea of how to solve this or at least
some guidance towards a solution

--
Best Lasse