Data Flow Event Handler: File Being Used By Another Process, Can't Move
Posted on 2011-02-20
I have an onError event handler attached to my Data Flow task so that just in case I get a CSV file that is mis-formatted, I can move it into a Bad File folder.
The onError event fires, but it won't move the file because it says it is being used by another process. I do not get this same type of error later in the Control Flow of the package when I attempt to move the file after successful processing.
Any ideas on how to release the file from the process first and then move? I'm pretty sure it's being held by some DTS process but I have to believe it can be released and then moved.