• Normally no, because the load happens in a transaction.

    It depends a bit on the settings of the OLE DB Destination. You might want to lower the batch size to try if batches are committed more quicker.

    At a restart, what you would have to do is check the destination which rows are already loaded and exclude them from the source.

    But, having smaller transactions/batches slows down the loading speed.

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