Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Leonard Deleting Rows in Incremental Loads – Level 5 of the Stairway to Integration Services RE: Deleting Rows in Incremental Loads – Level 5 of the Stairway to Integration Services

  • December 12, 2011 at 6:42 am

    #1420040

    I recently was surprised to find importing a large number of wide rows it was faster to use a SSIS merge of two sorted inputs with a conditional split rather than a lookup diverting no matches to a no match connection. Have you seen a general rule when it is optimal to use the merge rather than a lookup?