• In my experience, you should always stage your data on the local server before doing any manipulation and / or merging. So for dawalker, extract new information in native form from the source server to your warehouse server before you transform and load.

    I also use checksum to detect changes. Much faster!

    -------------------------------------------------------------------------------------------------
    My SQL Server Blog