Recently while developing SSIS packages, the Visual Studio (SSDT) got crashed.
After restarting the Visual Studio and trying to execute the package we got the below error.
System.IO.IOException: The process cannot access the file ‘c:\folder\ssisproject.ispac’ because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.Delete(String path)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder. IncrementalBuildThroughObj(IOutputWindow outputWindow)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.
BuildIncremental(IOutputWindow outputWindow)
ISPAC file is the integration services project deployment file containing the packages and the parameters.
The fix is to open task manager and end the DtsDebugHost.exe task.
DtsDebugHost.exe is the SSIS Debug runtime process that executes the package.
Hope it helps..
Thanks. Worked for me.
LikeLike
Great
LikeLike
Works! Thank you very much!
LikeLike
great it helped you Mitch
LikeLike
This was very helpful. Thanks for sharing this fix!
LikeLike
Happy to help !
LikeLike
This helped me. Thank you so much .
LikeLiked by 1 person
Thanks for the comments Gaurav. Glad it helped.
LikeLike
This helped alot! thank you
LikeLiked by 1 person
Thanks for for you comment
LikeLike
It worked! Thank you!
LikeLiked by 1 person
Thanks for for you comment
LikeLike
Thank you! It worked!
LikeLiked by 1 person
Great 👍
LikeLike