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

  • Quick thought, grab the SysInternals utility which shows open files, cannot remember the name but should be easy to find. It will show if any process is accessing the file. I've come across this problem quite few times, most of the time SSIS was the culprit, not closing the files after simple operations like row counting etc.

    😎