SQL SSIS Closing Files already in use Sometimes when running SSIS packages on flat files, I receive error: "The process cannot access the file because it is being used by another process".

Another person already has file opened.

Is there a way for SSIS to manually close the file, so it can be processed?
I assume SSIS needs admin rights in the folder its processing.
I don't see "Close file" option in FileSystem task? Should I maybe use Powershell?

Please let me know of best options, I prefer SSIS first.

Thanks,
When an application opens a file, it specifies what type of access is allowed by concurrent processes (none, read, read/write, etc.). SSIS cannot change that. The file must either be closed or the other process terminated. 

Although you could programmatically identify the terminate local processes owning a file handle, that can be challenging with remote processes and/or UNC paths. Personally, I wouldn't go there. A better solution is to have users copy files to a staging location once they are ready and have the ETL process them up from there.