I am trying to put a bad input file into another folder when I have load errors. The file in question is a comma delimited CSV that occasionally has commas in the wrong place, and then the file will not load because the data doesn't match the layout.
I tried to move the file to another folder (all processing is within a for-each-file loop), but the flat file connection manager apparently won't let go of the file for the "move file" process to work. I have the "move file" (File System Task) process in the event handler for when this "Flat File Source" object errors out.
I get the following error when the "move file" process attempts to move the file that is being processed: "The process cannot access the file because it is being used by another process."