SQL Server Performance Forum – Threads Archive

Error in locked process

My DTS package in production failed and gave me the following error: The process can not access the file because it is being used by another process.
Can not open a log file of specified name. The process can not access the file because it is being used by another process. I killed some process but still the problem exists. What shoudl I do? Please help!
Here are returned messages:
Error string: The process cannot access the file because it is being used by another process. Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100 Error Detail Records: Error: -2147024864 (80070020); Provider Error: 0 (0)
Error string: The process cannot access the file because it is being used by another process. Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error: -2147024864 (80070020); Provider Error: 0 (0)
Error string: Cannot open a log file of specified name. The process cannot access the file because it is being used by another process. Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4700 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147024864 (80070020)
Error string: The process cannot access the file because it is being used by another process. Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100 Error Detail Records: Error: -2147024864 (80070020); Provider Error: 0 (0)
Error string: The process cannot access the file because it is being used by another process. Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error: -2147024864 (80070020); Provider Error: 0 (0)
Error string: Cannot open a log file of specified name. The process cannot access the file because it is being used by another process. Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4700
CanadaDBA

Here is info from Package logs: <pre> Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:The process cannot access the file because it is being used by another process. (Microsoft Data Transformation Services (DTS) Package (80070020): Cannot open a log file of specified name. The process cannot access the file because it is being used by another process. ) Step Error code: 80070020 Step Error Help File<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qldts80.hlp Step Error Help Context ID:1100 </pre> CanadaDBA

As it says another process is accessing your file. If you don’t know what process it is (an ftp process, a file editor, another batch job that use the file etc) download filemon from www.sysinternals.com and check.

Have you running others scheduled jobs? Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thank you for introducing the website.
I had to reboot the server while no one was working with it. After that, The DTS package worked. Before reboot, I tried to run the DTS again but again got the error. I am wonder why this happened while I couldn’t see any running/sleeping processes.

quote:Originally posted by Argyle As it says another process is accessing your file. If you don’t know what process it is (an ftp process, a file editor, another batch job that use the file etc) download filemon from www.sysinternals.com and check.

CanadaDBA

It doesn’t have to be related to a process in sql server, it can be any process on the server itself. The error is from the operating system and not from sql server.

Hi, What was the outcome of this topic? Could you solve the error?
I’m experiencing the same at this moment. Regards,

Do you have any anti-virus package installed on the server or corresponding server that is used by DTS. May track the process using PROFILER. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>