BIDS error:Unable to access the package file. Make sure the file exists and you have permission to access it.. The process cannot access the file because it is being used by another process.

I have a sequence container where I am calling dtsx packages to run in parallel. When I am executing sequence container,some of the packages are failing with the below error:

Error 0x80070020: Unable to access the package file. Make sure the file exists and you have permission to access it.. The process cannot access the file because it is being used by another process.

If I execute the container again,then its completing successfully.Also if I run the packages separately outside of sequence container,they are executing successfully.The same container is also executing successfully in a different environment.So,could n't understand what might be the issue.

can some one please suggest.

Thanks,
Meri LuckyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason clarkDBA FreelancerCommented:
first thing you should perform to check that permissions to access these folders and files granted. So, if all the permissions are granted. Since you may be accessing the package located on the same system and not on any network share,access permission denied issue as this point of time was ruled out.
check the file system activity using Process Monitor utility. Run the process monitor utility and check the issue:
Further you may have a look here on this: https://blogs.msdn.microsoft.com/dataaccesstechnologies/2012/01/19/ssis-error-0x80070020-unable-to-access-the-package-file-make-sure-the-file-exists-and-you-have-permission-to-access-it-the-process-cannot-access-the-file-because-it-is-being-used-by-another-proces/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jason clarkDBA FreelancerCommented:
No response from user..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.