File system task: copy in for each loop
-
i am getting a error; The process cannot access the file as it is being used by other process.
-
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
-
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply