In this article, we will learn How to fix Microsoft SSIS process cannot access ISPAC file.
Complete Error Message:
Severity Code Description Project File Line Suppression State Error System.IO.IOException: The process cannot access the file 'Complete File Path *.ispac' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalDelete(String path, Boolean checkHost) at System.IO.File.Delete(String path) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.IncrementalBuildThroughObj(IOutputWindow outputWindow) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.BuildIncremental(IOutputWindow outputWindow) 0
Cause: During the development, we are not able to run our SSIS Package. This is because our previous SSIS execution is crashed. There is probability we have multiple instances for DtsDebugHost.exe is running it is blocking our SSIS Package execution.
Resolution: It is simple to resolve. You need to kill DtsDebugHost.exe entries from the Task Manager. Before this ensure no other SSIS package is running. Following are resolution steps
Please refer to the following image for more details.
Kill DtsDebugHost.exe from Task Manager
After this try to run your SSIS package one more time. Maybe it will resolve your issue.
Please login to post your valuable comments.
Get the latest vLemonn news first