June 28, 2006 at 10:02 am
Error opening datafile: The system cannot find the path specified
I have a dts package the when scheduled fails with this error:
"Error opening datafile: The system cannot find the path specified"
the failure occurs only when the dts job is scheduled thru sql enterprise mgr
when run from enterprise manager in the data transformation area, the dts job runs successfully. the job basically loads a *.csv file into a sql table. the paths for the input file are valid and visible on the sql server. the user is a valid user with admin access
entire error message
Executed as user: DRITZDOMAIN\Administrator.
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.
path:L:\
June 28, 2006 at 10:29 am
Is that a valid path on the SQL server when logged in with the account SQL Server runs on? Does the account that the SQL Server Agent runs on have access to that share? Does it work if you use a UNC path instead?
June 28, 2006 at 2:05 pm
thanks, using a unc name does make a difference
May 11, 2009 at 12:31 am
just add this in the step1 of your job step
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSRun" \
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply