Kongta
asked on
execute SSIS even when source is missing
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
rgds
kongta
thx for any Input
rgds
kongta
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I see where the way should go:
http://sql-articles.com/articles/bi/file-exists-check-in-ssis/
not right there yet, some Bugs but guess get it fixed
thx for your help
rgds
Kongta
http://sql-articles.com/articles/bi/file-exists-check-in-ssis/
not right there yet, some Bugs but guess get it fixed
thx for your help
rgds
Kongta
ASKER