Monday, 16 December 2013

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

Case
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.


40 comments:

  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 ?

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

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

    ReplyDelete
  4. great stuff! worked perfect for me.

    ReplyDelete
  5. Thanks it worked for me as well.

    ReplyDelete
  6. Awesome. it worked. thank you!

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

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

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

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

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

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

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

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

    ReplyDelete
  14. Easy fix for a dirty error... thanks a lot..

    ReplyDelete

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...