• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1104
  • Last Modified:

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?
1 Solution
Dear Friend,
Check the answer I gave here:

rschaeferhigAuthor Commented:
This is basically what we thought we had to do, but I was hoping there was a way to set the Data Flow to fail if the input file was not present.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now