Monday, 16 December 2013

The process cannot acces the file 'ssisproject.ispac' because it is being used by another process.

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)

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.


  1. Replies
    1. It'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 ?

  2. Thanks! For new deployment model this processes names are: "SSIS Debug Host.exe" and "SSIS Debug Host32.ex"

  3. If its not in Processes tab, it will definitely be in Details tab in newer versions of Windows

  4. great stuff! worked perfect for me.

  5. Thanks it worked for me as well.

  6. Awesome. it worked. thank you!

  7. Very helpful, I only noticed that the name changed, instead of "DtsDebugHost" it's "SSIS debug host"

  8. In Windows 10 the process is called SSIS Debug Process

  9. how do we identify which one to to endtask when we have multiple SSIS debug host in process tab of task manager?

    1. I just kill them all! Most of the time I'm the only one debugging on my machine.

  10. Thank you! You saved me a lot of frustration. :)

  11. THanks a lot! I was badly stuck at this point.

  12. Excellent, it works exactly for me. Thanks a lot.

  13. Thank you so much! Prevented a lot of frustration!


Please use the SSIS MSDN forum for general SSIS questions that are not about this post. I'm a regular reader of that forum and will gladly answer those questions over there.

All comments are moderated manually to prevent spam.

Related Posts Plugin for WordPress, Blogger...