• Great article!!! Been looking for a good means to accomplish this as well (eg. resolving the SSIS limit with a script task component and no native SSIS task to instigate the MERGE in an incremental load).

    The use of the sproc I would think should provide a performance bump as well over the script task (which is how I'd been implementing this previously).

    Cheers!

    - Savage