ms-techie (2/23/2014)
Our SSIS packages are automated to run in production via JOBS which use the DTExec.exe line to invoke the individual packagesWe have a total of 25 jobs like this. These Jobs are INDEPENDENT of each other. So the OUTPUT of one Job , does not affect any other jobs.
Some of the jobs are jobs are scheduled to RUN , at the same-time .(Since they dont depend on one another ) and the business wants data at the same time .
Now in this scenario, we get the following error
"The process cannot access the file because it is being used by another process " and then the job fails . This is because DTExec.exe Process is being accessed by many jobs
Is there a way , wherein , 3 jobs can be scheduled to RUN at the same time , without getting the above error. Is there some settings that needs to be done on the Server , where this job runs.
Pls help
You can run a lot of packages at the same time (depends a bit on the number of processors). You don't have to do anything to enable that. Just make sure there are no conflicts at the source/destination, where your error is probably happening.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP