asked
The process cannot access the file because it is being used by another process.
I get the same problem. A parent package in solution A executes a child package (Define_Segments_.dtsx) in solution B. I use VisualStudio 2008 Sometimes it runs and sometimes it fails with these 2 messages Error 0x80070020 while loading package file "\\SERVER1\h_drive\Visual Studio 2008\projects\Define_Segments_.dtsx". The process cannot access the file because it is being used by another process. Error: Error 0x80070020. Unable to access the package file, "\\SERVER1\h_drive\Visual Studio 2008\projects\Define_Segments_.dtsx". Make sure the file exists and you have permission to access it. How to fix this bug? Thanks Rita
This isn't necessarily a bug but a way of protection for your file(s) and data. If a file is being created, it is locked until the creation of the file is completed. If you try to access the file during this time, you will get this error. The trick is to come up with a method of knowing when the file creation is completed and free to access.
19 People are following this question.
