Post reply

How do I resolve - "Warning: 0x80070020 at ... The process cannot access the file because it is being used by another process."

  • October 30, 2014 at 4:16 am

    #291623

    Now I'm working on a new project,that involves converting an xml from a dynamic url source to a csv & then reading that in (this is done so we can keep historical files for x number of days,since the URL don't keep forever)

    I got a scipt to do the conversion,now last night I ran the test to get all data in,over a couple of million records,the script did not fail,but I got the following problem

    Warning: 0x80070020 at Move Data, CSV [9]: The process cannot access the file because it is being used by another process.

    Error: 0xC020200E at Move Data, CSV [9]: Cannot open the datafile "abc.csv".

    Now the FEL Sleep holds the job for 10 seconds & that seems to have stopped the same issue when dealing with small data files.

    So the root question would be: What holding the file is use,why and why hasn't it released the file.

    And the secondairy question is then: how to prevent this in the future

  • October 30, 2014 at 4:46 am

    #1755729

    Maybe you could try putting the export to CSV in its own Sequence container?

    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 3, 2014 at 12:42 am

    #1756268

    Tried that over the weekend,same result,the file could not be opened cause it's in use.

  • November 10, 2014 at 7:14 am

    #1757421

    ok in the end I added a copy file delete file step into the package

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply