August 3, 2009 at 5:53 am
hi all,
i am trying to execute a dts package. and logs will be stored in other location
when i am executing the package, i am getting the following error.
can any one help me on this
cmd :
c:>DTSRun /S ms2k /E /N testdts /L \\tktmc\test\log.txt /W 0
ERROR:
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset Provid
er
Help file: DTSFFile.hlp
Help context: 0
Error Detail Records:
Error: 5 (5); Provider Error: 5 (5)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset Provid
er
Help file: DTSFFile.hlp
Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
August 3, 2009 at 7:56 am
I hate to be a smarta$$ but access is denied to the file you are trying to access..
In all seriousness though, the user (either you or the user that SQL Server is running) under is trying to access the file and it is not permitted. You need to determine what user is trying to access the file and verify that they have the needed access.
CEWII
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply