I do have a SSIS package which includes 3 dataflow-events, two Imports from Excel and one flatfile-source. All works fine. I now experienced that one time, the .csv was missing for the flatfile-source because it was deleted by mistake. two day later I noticed that the full package was not executed because of one missing file of three. Is there a way to let the package run even when one source is missing? I have the three dataflow-events packed into a sequence-container.
thx for any Input