November 6, 2009 at 10:04 am
Why the package Ids can be an issue?
November 6, 2009 at 10:58 am
You are providing limited information and havn't provide any feedback on my suggestions. Try all my suggestions above and let me know the individual results of each test I suggested and then and only then will I be able to solve your problem.
November 17, 2009 at 7:17 am
Hi,
I have regenerated the package ID, and I still have the have the issue while running in debug mode. Here is the output of the execution progress
Package CUBEBUILD
Task Load Goals Data
Start, 9:06:36 AM
Validation has started
Validation is completed
Error: Error 0x80070020 while loading package file "D:\SSIS Packages\LOAD Goals.dtsx". The process cannot access the file because it is being used by another process. .
Task Load Goals Data failed
Finished, 9:06:36 AM, Elapsed time: 00:00:00.078
The package is very simple. It contains just two Execute SQL tasks to update some tables. I can confirm that I am the only one on this box running some SSIS package.
Thanks all for your help.
Thanks,
Rem
November 17, 2009 at 7:22 am
Are you able to rename the dtsx file from Windows Explorer? We need to find out whether the problem is with the package file itself, or with a file that the package is referencing.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 17, 2009 at 7:50 am
My guess is that the problem is in the dataflow of the packages. This would be impossible to troubleshoot with out the package itself, because of environment variables,packages, expressions. If you want to attach your package in the 2005 Version, I'll take a look and see if I see anything that looks peculiar.
November 17, 2009 at 8:30 am
HI,
I am able to rename the .dtsx without any problem.
One thing is when I run the parent package in BIDS, the child package failed. At this point I can re-execute the child package, and I don't get the error. It seems there is something with the load of the child package.
The last thing is I have this kind of problem with more than 1 parent-child package combinations.
Thanks for you help,
Rem
November 19, 2009 at 7:35 am
Hi Rem,
Is your issue resolved?
I am getting the same error. I restarted the server thinking it might be locked by some process.
I have observed that when the parent calls the child package, the child package gets open in BIDS but it is not executed and i get the error "The process cannot access the file because it is being used by another process."
I am also using VS2008.
-Vikas Bindra
November 19, 2009 at 7:56 am
Believe it or not I got the same error yesterday and in bids 2005 on a package that that been working for months in manual mode in the IDE.
My guess is that this issue is related to a service pack or something. I only had the issue one time and it worked the next time. If someone is consistently getting this error I would recommend that they open a support ticket from there msdn subscription to get to the bottom of it. I didn't see anything in my package that would cause this error, ran it several times again and it worked fine.
November 19, 2009 at 8:14 am
Hi llitvin,
I ran the package for 7 days in a loop yesterday and it worked fine. But it is giving pain when I ran it today. :crazy::(
It can not be the security patches as there were no patched or any upgrade done on the server since last 2 weeks.
I tried changing ID, deleting and adding the package again. Now I am trying by renaming the package, hope it works.
-Vikas Bindra
November 19, 2009 at 8:18 am
Renaming the package worked, it is executing perfectly now.:cool:
I don't believe it but it is working.
-Vikas Bindra
November 19, 2009 at 8:24 am
Obviously I don't know exactly what your package is trying to do but....
If your package is reading from a source file such as a csv, spreadsheet, text file etc...
Then you need to make sure that you close it if you have it open at the time of running the package - i.e. make sure its not open in your task bar in windows otherwise your package will try to read the file that you already have open.
Hope that helps.
Lewis
November 20, 2009 at 7:29 am
Hi All,
I still have the issue. If I rename the packages, this mean I will need to change a lot of parent-child combinations packages. These were running for months without any issues.
Vinkas, did you renamed only the parent, only the child or both?
This is a pain.
Rem
November 20, 2009 at 7:39 am
I agree with you that this is a pain as I have been through it. My packages were also running fine for months. and then this error came:crazy:
I renamed only the child as I was getting this error only for 1 child package others were running fine.
What i did is as follows:
1. Save a copy of package
2. Removed the package from the solution.
3. Renamed the saved copy (to say X from Y)
4. Added the renamed package (X) back to the solution.
5. Change the connection string in the parent package to point to the renamed package(X)
And it worked fine.
After executing it once I tried to rename it back to original (Y) but it again failed with the same error.
Then i got frustrated and renamed it back (to X) and it started working again.
After that I went home yesterday. I logged in today and renamed it back to (Y original name) and it is working fine.:unsure:
WHY WHY WHY..i don't know...this is very weird but it is working now. I am going test once more on Monday with my weekly runs.
-Vikas Bindra
December 1, 2009 at 7:14 am
Hi Vikas,
I will try to do this gymnastic this week with the packages I have problems.
Did you bring all the original names of your packages?
I will keep you posted.
Thanks
REm
December 1, 2009 at 7:27 am
Rem-487422 (12/1/2009)
Hi Vikas,Did you bring all the original names of your packages?
I will keep you posted.
Thanks
REm
Yes I did bring the original names back and it is working since then...
-Vikas Bindra
Viewing 15 posts - 16 through 30 (of 33 total)
You must be logged in to reply to this topic. Login to reply