Post reply

Writing to the same file within a DF, The process cannot access the file because it is being used by another process

  • March 30, 2009 at 7:52 am

    #132748

    Hi, help please.

    I'm writing twice to the same file in one Data Flow task and I get the error: The process cannot access the file because it is being used by another process

    I have read that it's a bug and can't write to the same file within a Data Flow task.

    Is there a simple workaround?

    Regards

  • March 31, 2009 at 6:43 am

    #969038

    ismail casper (3/30/2009)

    Hi, help please.

    I'm writing twice to the same file in one Data Flow task and I get the error: The process cannot access the file because it is being used by another process

    I have read that it's a bug and can't write to the same file within a Data Flow task.

    Is there a simple workaround?

    Regards

    Do you write from 2 different components to the same file? If that is the case, this is not a bug. The components cannot share the same file handle, so each component tries to open the output file and one of them will fail certainly. You have to use only one flat file destination. Combine the data flow from both sources using a Merge transformation. Then direct the combined data flow to the output flat file.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • March 31, 2009 at 6:56 am

    #969048

    Thank You very much!

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

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