February 13, 2009 at 2:26 am
Hello, I have a DTS package which can be executed successfully, but when I create a job schedule - it does not start and produces the following error message.
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 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.
Looking at the error, it says it cannot find the path, which is confusing because the way I created the job was from the DTS.
Further info - the DTS is created on the actual server and uses window authentication.
Is there something I'm doing wrong or need to do something different?
Any help appreicated, Thank you.
February 13, 2009 at 11:06 am
I've seen this error when accessing a file that is not on the server where the DTS package is running. If that's the case here, try using a UNC path for the file.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply