• You can put the ForceExecutionResult property of the data flow to success, so the data flow never fails. However, if another error occurs in the data flow not related to the those you described, you won't notice this (unless you check the logging).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP