I'm downloading CSV files using FTP and I loop through them to import into a MS SQL staging table. What I want to do is move successfully imported files into an archive folder and move failed files into a failed folder.
My problem is that I can't find a way to have a red error/failure arrow coming out of my Data Flow Task, and inside the Data Flow task, where I can see the red arrow coming out of the OLE DB task, I can't find a way to have a File System Task!
Am I missing something obvious?
