January 4, 2017 at 1:00 pm
i am getting a error; The process cannot access the file as it is being used by other process.
January 4, 2017 at 2:16 pm
nicepraveenb (1/4/2017)
i am getting a error; The process cannot access the file as it is being used by other process.
I usually use Process Monitor to see who/what is accessing the file. If you want to try that route, you can download Process Monitor from here:
https://technet.microsoft.com/en-us/sysinternals/processmonitor.aspx
Sue
January 13, 2017 at 1:38 pm
Maybe coordinate with your team to determine who can have access to the file and when. That is what file and folders permission are also built for 🙂 . As far as how forum members can help, well I would release that lock if I could but that is more the call of your team/what process needs to finish there/or your sys admin if someone opened an excel file and then left for a long lunch.
A more sustainable solution is to have all automated processes running under one scope , (we call them Jobs in the world of Sql Server). Have the Job Agent be the entity responsible for scheduling and running your processes, especially when there are dependencies (file A needs to load first, then file B etc...).
----------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply