SQL Server Performance

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

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Mar 30, 2009.

  1. Ismailc New Member

    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 processI 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
    Ismailc, Mar 30, 2009
    #2

  2. satya Moderator

    Are you closing that file open process when it is finished, this is a by default issue in order to continue for next time.
    satya, Mar 30, 2009
    #3

  3. Ismailc New Member

    Thanks for the assist,
    I don't think so, i don't know how.
    I have two flat file destinations being the same file within one DataFlowTask and writing one after the other.
    How do i close it?
    Regards
    Ismailc, Mar 30, 2009
    #4

Share This Page