• For incremental load, I guess you should use encryption techniques to find out actual updated records.

    In case loading the updated records in temp table.

    Also please let us know your package design and which part of your package is actually taking time.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂