Our SSIS packages are automated to run in production via JOBS which use the DTExec.exe line to invoke the individual packages
We 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.