Home Forums SQL Server 2005 SQL Server 2005 Integration Services File System Task > Move Files > Error - Process cannot access the file because its being used by another process RE: File System Task > Move Files > Error - Process cannot access the file because its being used by another process

  • It might be possible that the file download on your source directory is not complete and at the same instance you are trying to move the file. 2 Processes are accessing the same resource.

    Create an onfailure event and loop through the rest of the files in the folder or write a script task to Open each file (catch an exception if the file cannot be open) before moving.