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

Posted by Marlon on Stack Overflow See other posts from Stack Overflow or by Marlon
Published on 2010-05-03T13:09:09Z Indexed on 2010/05/03 13:48 UTC
Read the original article Hit count: 411

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.

© Stack Overflow or respective owner

Related posts about ssis

Related posts about filesystem