DTS schedule error -
01-21-2005
, 08:57 AM
I've got the problem. I created DTS package that copy data from SQL Server to
the text file.
The DTS successfully execute from 'Data Transformation Services', but when
DTS schedule to run in SQL Server Agent it gives the error.
DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1,
Error = -2147467259 (80004005)
Error string: Error opening datafile:
The system cannot find the path specified.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider Help file: DTSFFile.hlp Help context: 0 Error Detail
Records:
Error: 3 (3); Provider Error: 3 (3)
Error string: Error opening datafile:The system cannot find the path
specified.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider Help file: DTSFFile.hlp Help context: 0 DTSRun
OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete.
Process Exit Code 1. The step failed.
Is anybody can help, please.
thanks. |