I have a situation in ssis package. There could be customers with same names but different addresses. So, I save as different customers (id:1, 2, 3) in Customer table by creating different ids. After saving the Address table (id: 1, 2, 3) here I gets the problem to save CustomerAddress table. On fuzzy lookup the customer id to match with the actual data it always gives the first match so I am getting the combination for CustomerAddress as 11, 12, 13 instead 11, 22 and 33. Is there any tool available in SSIS so after a match (11) it goes for different match in Customer for next match. Hope my explanation is clear. Thanks.