Home Forums SQL Server 2005 Business Intelligence SSIS File Rename - The process cannot access the file because it is being used by another process RE: SSIS File Rename - The process cannot access the file because it is being used by another process

  • Good stuff, glad you got this resolved.

    This is less of a problem on 2K8 R2 and later, not certain why, just my experience. As a rule of thumb, I try to use script tasks for all non-data operations rather than the File System Tasks, one can close the file for further operations without having to rely on the SSIS behaviour.

    😎