SSIS: The process cannot access the file ‘*.ispac’ because it is being used by another process

~ Ajit Patra

Recently, while developing an SSIS package we got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”.

We tried to close SSDT and run it again but, we still got the same error while compiling. Then, after searching over internet, we got the solution:

  1. Go to Task Manager–> Details Tab.
  2. Locate the process “DtsDebugHost.exe“. Kill this process. There might be multiple instances of this process. Kill all of them as shown below:

b

After doing this, we tried to compile the package again and it was successful.

Hope it helps !!

Advertisement

Published by Ajit Patra

25 thoughts on “SSIS: The process cannot access the file ‘*.ispac’ because it is being used by another process”

  13. it works but just the first time when i run a second time does not work and returns the same error

    Like

    Reply

  14. Hi, thank you for the advice.

    Just to let everyone know, the name of the processes have been renamed to: “SSIS Debug Host”.

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.