I want to run an SSIS 2012 package but I'm getting an error:
ispac file in use by other process |
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)
Solution
You have probably already restarted SSDT, but that didn't help. Open the Task Manager (Ctrl + Shift + Esc) and locate DtsDebugHost.exe under Processes and end that process (could be multiple times, end them all). Now try running the package again.
Task Manager, End SSIS Debug Host |
This happens when SSDT/Visual Studio crashes during runtime. If you kill SSDT then the SSIS Debug Host will still be active locking the ISPAC file.
Very Helpful
ReplyDeleteThanks
ReplyDeleteDidn't work
ReplyDeleteIt's a bit too easy to just say it didn't work. Please provide more information. Did you see (and kill) the processes DtsDebugHost.exe ?
DeleteThanks! For new deployment model this processes names are: "SSIS Debug Host.exe" and "SSIS Debug Host32.ex"
ReplyDeleteThanks, that helped
DeleteHelped
ReplyDeleteIf its not in Processes tab, it will definitely be in Details tab in newer versions of Windows
ReplyDeleteThanks Janani, this worked - Senthil
Deletehelped! thanks
ReplyDeletespot on advice!
ReplyDeletethanks
It worked, Thanks !
ReplyDeleteThanks it worked for me (Y)
ReplyDeletegreat stuff! worked perfect for me.
ReplyDeleteThanks it worked for me as well.
ReplyDeletethank you... it's work
ReplyDeleteThanks.
ReplyDeleteVery helpful. Thank you
ReplyDeleteThanks. It worked for me
ReplyDeleteAwesome. it worked. thank you!
ReplyDeleteVery helpful, I only noticed that the name changed, instead of "DtsDebugHost" it's "SSIS debug host"
ReplyDeleteit Helped
ReplyDeleteIt Helped :) Thank You.
ReplyDeleteWorked :)
ReplyDeletehow do we identify which one to to endtask when we have multiple SSIS debug host in process tab of task manager?
ReplyDeleteThank you! You saved me a lot of frustration. :)
ReplyDeleteworks like a charm!
ReplyDeleteTHanks a lot! I was badly stuck at this point.
ReplyDeleteAwesome. Thanks!
ReplyDeleteExcellent, it works exactly for me. Thanks a lot.
ReplyDeleteThank you so much! Prevented a lot of frustration!
ReplyDeleteWorks for me. Thank You.
ReplyDeleteThanks a lot!! :)
ReplyDeletePerfect - thanks!
ReplyDeleteIt works, thank you!
ReplyDeletethank you
ReplyDeleteThanks a lot. It helped
ReplyDeleteEasy fix for a dirty error... thanks a lot..
ReplyDeletethis works
ReplyDeleteGreat fix, thanks for your post it helped me out.
ReplyDeletethank you
ReplyDeleteThanks for this. You solved my problem :-)
ReplyDeleteThank you! And concur, that if it's not in the Process Tab, then you gotta check the Details Tab
ReplyDeleteAwesome and I thank you
ReplyDeleteThis was a huge help. Thank you.
ReplyDeleteIt worked, Thanks for the help
ReplyDeleteThanks, that solved it for me too.
ReplyDeleteStill works, thank you!
ReplyDeleteVery helpful information...Thanks a lot
ReplyDeleteThanks it worked
ReplyDeleteIt worked for me. Thank you so much!
ReplyDelete