March 9, 2010 at 10:38 am
Hi Vikas,
Did you faced the problem again?
Rem
September 23, 2010 at 9:26 pm
I've had this problem before and in my case the solution was easy, but at the same time, it took me for ever to find because my error was so basic I never checked it. I was checking everything else.
There are probably many causes, but in my case I was reading the file in a script component in the data flow. For some reason I had commented out the reader.close statement. So, the file was still in use by the data flow script component when it tried to move the file off to an archive directory.
Here's an example of what my error was, maybe this will help you (I know it was a stupid error, but sometimes it's the simple things that get you)
This is what I had when I was getting the error:
public override void PostExecute()
{
base.PostExecute();
//_reader.Close();
}
And to fix it I just had to change it to this:
public override void PostExecute()
{
base.PostExecute();
_reader.Close();
}
October 19, 2010 at 8:19 am
I also had this problem. Two of my child packages were failing and I couldn't figure out why. Then I noticed the two that were failing were the only two whose connetion managers were set up using the full file path -- they were pointing to \\server\folder\folder2\<pkgname>.dtsx while the others were pointing to A:\folder2\<pkgname>.dtsx. Seems odd, but once I made them all point to A:\folder2\<pkgname>.dtsx, I stopped getting this error.
March 2, 2016 at 9:21 am
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.
I tried everything that was suggested in this forum, without success.
Please Help.
Rita
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply