Home Forums Data Warehousing Integration Services The process cannot access the file because it is being used by another process - small files are locked a bigger one works fine RE: The process cannot access the file because it is being used by another process - small files are locked a bigger one works fine

  • The fact that the larger files do not have the problem suggests that this is a timing issue rather than a logic/coding issue.

    You could try calling .Dispose() rather than .Close(). You could also try adding a Thread.Sleep(nnnn) to test the possibility of it being down to timing.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.