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 !!
This was very helpful!!! Thank you a bunch.
LikeLike
Thank you very much for this helpful tip, Much appreciated.
LikeLike
Excellent. Bundle of thanks. Saved life
LikeLike
Very helpful. It works. Thanks Ajit.
LikeLike
Thanks! Worked like a charm
LikeLike
Thanks! You saved lot of time!
LikeLike
Thanx It works
LikeLiked by 1 person
Thanx so much…….
LikeLiked by 1 person
Thanks.
The process name might be “SSIS Debug Host”, too
LikeLiked by 1 person
Thanks, it worked.
LikeLiked by 1 person
I am not able to find the process that needs to be stopped. Can someone help me?
LikeLike
Hi Abhishek, please see the screenshot for reference to find the process.
LikeLike
Thanks, you saved me a reboot 🙂
LikeLiked by 1 person
Thank you. It worked.
LikeLiked by 1 person
it works but just the first time when i run a second time does not work and returns the same error
LikeLike
Every time you get this error you need to kill all the instances of this process. Thanks.
LikeLike
Hi, thank you for the advice.
Just to let everyone know, the name of the processes have been renamed to: “SSIS Debug Host”.
LikeLike
Thanks Pasi. Yes, the name is “SSIS Debug Host” in Processes tab, however, the name is “DtsDebugHost.exe” in Details tab of Task Manager.
LikeLike
It worked for me like a Miracle
LikeLiked by 1 person
Thank you!!
LikeLike
Thank You
LikeLike
Thank U sooo much!! this information save me ❤
LikeLike
Awesome, this helped me a lot….thank you
LikeLike
Very helpful, thank you for the post.
LikeLike
Very helpful, Thank you so much
LikeLike