Hi all I created a job for execute SSIS package using Execute package task (in file system). But after I run the job using BIDS I got error below. Error 1 = Error: Error 0x80070020. Unable to access the package file, "D:\SSIS\U-Marketing\Packages\UMI_TOPS\CF_STG1_TOPS_SRC_UMI_REDEMPTIONOFFER.dtsx". Make sure the file exists and you have permission to access it. Error2 = Error: Error 0x80070020 while loading package file "D:\SSIS\U-Marketing\Packages\UMI_TOPS\CF_STG1_TOPS_SRC_UMI_REDEMPTIONOFFER.dtsx". The process cannot access the file because it is being used by another process.. I search for this issue and try to following the step but still cannot fix the problem such verify permission of the specific path. If you have any suggestion please help. Thank you in advance.

Make sure the file isn't locked by another process. There are tools on the web that can locate these process and optionally unlock the file. Try restarting BIDS, maybe it's visual studio itself that is locking the file (I wouldn't be surprised).MCTS, MCITP - Please mark posts as answered where appropriate.

Thank you for your comment Koen Verbeeck. I already restart BIDS, SQL Server Service and server but still cannot get rid of the error(lock by another process). Do you have any idea about this? Please kindly suggest.

Like I said: find a tool that can track down which process is locking the file. An example: http://windowsxp.mvps.org/processlock.htmMCTS, MCITP - Please mark posts as answered where appropriate.

Thank you. I try Process Explorer and Unlocker but not found the process that lock the file. Any suggestion? Please help.

You do have permission on that folder, right?MCTS, MCITP - Please mark posts as answered where appropriate.

Yes, I grant full control to etl user.

Do you have any idea about this? Please kindly suggest. An other alternative: Process Monitor v3.03 (Microsoft, successor of Filemon): http://technet.microsoft.com/en-us/sysinternals/bb896645Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Thank you SSISJoost. No lock found. Can it be the other issue not locking process, not file permission?

have you created that package on your own(same user) or you edited some other(created by other user) package and trying to execute it..?

I created a job in my laptop and then move it to production server and try to execute it. Any suggestion? Please help.

Try disabling the antivirus on your machine and see if it works. Here is a link with the similar issue: http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/01/20/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-process.aspxPlease mark the post as answered if it answers your question

I am still facing the same issue as the packages are created other machine .. and i edited it on my machine,, I deployed it sucessfully... When i run in cmd its working fine.. but whn i am running it in sql job.. it fails to load the package or to execute the package ... check once whether its working from cmd prompt.. :(

Try disabling the antivirus on your machine and see if it works. Here is a link with the similar issue: http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/01/20/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-process.aspxPlease mark the post as answered if it answers your question

Thank you DotNetMonster, The package run successfully. One more question, I wonder why this issue happen because the other jobs can run complete(using SQL Server Agent) without disable anti virus.

Thank you DotNetMonster, I will contact system admin to disable it and try again.

it all depends upon the algorithms that these AV use. it could be the access rights on the package file or the executable, the resources it accesses when it runs and the way AV calculates it being as a threat.Please mark the post as answered if it answers your question