SSIS - How to handle missing flat file in dataflow task
I have an SSIS package that is a simple dataflow task. I have a mail task off the data flow task as a "failure" task to email me if the dataflow fails. The dataflow consists of a flat-file source to an OLEDB destination. If I delete the input file and run the package the data flow task "fails" but never goes to the mail task. If I open the data flow task the flat-file source is red and that's it. In the Progress window it says the flat-file source component failed in pre-execute.
Other than adding a step prior to the data flow to check for the file and email if it is missing, is there a way to get the data flow task to fail and just fall through to the failure mail task in the package?