Inside my data flow task I have a Source File and a Destination OLE DB. Outside this, in the control flow, I have my data flow task, on Failure (red line), configured to move the files to a "failure" directory where I archive.
When I run the job, and for some reason a row in the CSV has an extra comma the entire SQL Job fails (I'm running SSIS via a sql job), no "failed" files move to the failed directory and I'm basically dead in the water.
I've tried configuring inside the data flow task but there is no option for file operations. I've attached a screen shot of the Control Flow and Data Flow tasks.