Process cannot access the file error when running SSIS Admin Task to Create
When I run the SSIS Admin Task to Create a Dimension, I get the following error message:
- The process cannot access the
file "F:\BPC\Data\Webfolders\DMSales\System Files\SALESREP.DIM"
because it is being used by another process. : Location(MakeMemberLookUp)
If I run the task from SSIS directly it seems to complete successfully, but I can't tell for sure. It fails every single time when run from the Data Manager.
I have tried recreating the that dimension file(thinking that my old file is corrupted) but still i am facing the same issue.
Request you to provide some suggestions in this context that helps in fixing this issue.
Thanks in advance.