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.


Geplaatst door Joost van Rossum
Labels: , ,

51 comments:

  1. Nishar2 May 2014 at 11:15

    Very Helpful

    ReplyDelete
  2. İsmail Tutumluer23 June 2014 at 13:13

    Thanks

    ReplyDelete
  3. SQL Admin15 January 2015 at 00:45

    Didn't work

    ReplyDelete
    Replies
    1. Joost van Rossum15 January 2015 at 10:04

      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
  4. Unknown3 April 2015 at 08:50

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

    ReplyDelete
  5. Sumesh Babu R6 April 2015 at 11:57

    Helped

    ReplyDelete
  6. Unknown28 May 2015 at 16:08

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

    ReplyDelete
  7. Unknown17 July 2015 at 15:56

    helped! thanks

    ReplyDelete
  8. Fatima Soomro10 August 2015 at 13:41

    spot on advice!
    thanks

    ReplyDelete
  9. Unknown7 December 2015 at 21:34

    It worked, Thanks !

    ReplyDelete
  10. Roomi10 December 2015 at 20:28

    Thanks it worked for me (Y)

    ReplyDelete
  11. Matthew28 January 2016 at 02:16

    great stuff! worked perfect for me.

    ReplyDelete
  12. Unknown3 February 2016 at 04:51

    Thanks it worked for me as well.

    ReplyDelete
  13. heden8 February 2016 at 04:02

    thank you... it's work

    ReplyDelete
  14. Unknown2 March 2016 at 13:56

    Thanks.

    ReplyDelete
  15. Unknown16 March 2016 at 16:01

    Very helpful. Thank you

    ReplyDelete
  16. Unknown22 April 2016 at 10:48

    Thanks. It worked for me

    ReplyDelete
  17. Gail24 June 2016 at 21:29

    Awesome. it worked. thank you!

    ReplyDelete
  18. Mark de Groot14 July 2016 at 12:14

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

    ReplyDelete
  19. Hari kishan T28 July 2016 at 12:47

    it Helped

    ReplyDelete
  20. Unknown29 July 2016 at 13:55

    It Helped :) Thank You.

    ReplyDelete
  21. Unknown17 August 2016 at 14:56

    Worked :)

    ReplyDelete
  22. On7June7 September 2016 at 20:24

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

    ReplyDelete
  23. Audrey30 September 2016 at 16:14

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

    ReplyDelete
  24. Richard Zhang12 October 2016 at 12:55

    works like a charm!

    ReplyDelete
  25. Asif Kashmiri21 October 2016 at 13:17

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

    ReplyDelete
  26. Ben9 November 2016 at 20:15

    Awesome. Thanks!

    ReplyDelete
  27. Short Minutes15 November 2016 at 15:26

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

    ReplyDelete
  28. Unknown5 January 2017 at 16:23

    Thank you so much! Prevented a lot of frustration!

    ReplyDelete
  29. Unknown9 February 2017 at 17:28

    Works for me. Thank You.

    ReplyDelete
  30. Anshul20 June 2017 at 10:01

    Thanks a lot!! :)

    ReplyDelete
  31. Vinnie Boomer3 August 2017 at 23:59

    Perfect - thanks!

    ReplyDelete
  32. retnodewanti10 August 2017 at 12:21

    It works, thank you!

    ReplyDelete
  33. Unknown15 August 2017 at 08:32

    thank you

    ReplyDelete
  34. Unknown17 August 2017 at 06:45

    Thanks a lot. It helped

    ReplyDelete
  35. Murthy31 August 2017 at 13:08

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

    ReplyDelete
  36. Pai, Anantheshwar25 September 2017 at 16:00

    this works

    ReplyDelete
  37. Unknown6 November 2017 at 13:39

    Great fix, thanks for your post it helped me out.

    ReplyDelete
  38. Eric Berkowitz10 November 2017 at 16:05

    thank you

    ReplyDelete
  39. Unknown23 November 2017 at 16:10

    Thanks for this. You solved my problem :-)

    ReplyDelete
  40. Anonymous1 December 2017 at 14:54

    Thank you! And concur, that if it's not in the Process Tab, then you gotta check the Details Tab

    ReplyDelete
  41. nullspace1 December 2017 at 22:13

    Awesome and I thank you

    ReplyDelete
  42. Unknown13 December 2017 at 08:09

    This was a huge help. Thank you.

    ReplyDelete
  43. Unknown19 January 2018 at 14:57

    It worked, Thanks for the help

    ReplyDelete
  44. Martin Bring20 February 2018 at 14:42

    Thanks, that solved it for me too.

    ReplyDelete
  45. Me14 March 2018 at 10:52

    Still works, thank you!

    ReplyDelete
  46. Aftab19 March 2018 at 13:59

    Very helpful information...Thanks a lot

    ReplyDelete
  47. Dennis19 April 2018 at 12:02

    Thanks it worked

    ReplyDelete
  48. Unknown7 November 2019 at 17:20

    It worked for me. Thank you so much!

    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.

Subscribe to: Post Comments (Atom)
Related Posts Plugin for WordPress, Blogger...