SSIS For Each File Loop and File System Task to copy Files

Question

I'm using a files system task inside a for each loop container, just as described here: link text

However, when I execute the package I get this error: [File System Task] Error: An error occurred with the following error message: "The process cannot access the file 'C:\Book1.xlsx' because it is being used by another process.".

I do not have the file open, and I assume no one else does, as I am able to copy, and open, and overwrite the file.

Any suggestions would be appreciated. If you want an example package plz let me know.

Answer 1

I've figured out the problem. Be sure to not create File connections(you can see them in the Connection Mangers tab) that hold on to the same variable as the path you are using for the source file, in the File System Task.