Recently, while developing an SSIS package we got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”.
We tried to close SSDT and run it again but, we still got the same error while compiling. Then, after searching over internet, we got the solution:
- Go to Task Manager–> Details Tab.
- Locate the process “DtsDebugHost.exe“. Kill this process. There might be multiple instances of this process. Kill all of them as shown below:
After doing this, we tried to compile the package again and it was successful.
Hope it helps !!