SSIS For Each File Loop and File System Task to copy Files
- by Marlon
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.