I have got this message after I tried to run my package again and again after it was frozen.
This happened when Visual Studio crashes during run-time. If we kill Visual studio then the SSIS Debug Host will still be active locking the ISPAC file.
ERROR:
System.IO.IOException: The process cannot access the file 'E:\Comp_Optimizer\Solution\..................PATH.......ispac' because it is being used by another process.
Solution:
Open the Task Manager (Ctrl + Shift + Esc) and locate "SSIS DebugHost" under Processes and end that process.
This happened when Visual Studio crashes during run-time. If we kill Visual studio then the SSIS Debug Host will still be active locking the ISPAC file.
ERROR:
System.IO.IOException: The process cannot access the file 'E:\Comp_Optimizer\Solution\..................PATH.......ispac' because it is being used by another process.
Solution:
Open the Task Manager (Ctrl + Shift + Esc) and locate "SSIS DebugHost" under Processes and end that process.
