I have excel data as below Sl No House Address Name 1 #302,Bangalore Sanjeev Kumar 2 No 302,Bangalore Sanjiv Kumar 3 402, Chennai Radhakrishna Now I want The first three names are the same, These have to be made into 302 ,Bangalore as the Address and Name Sanjiv Kumar If any one faced with the same and could provide me a solution. Thanks, Nandu

I dont understand why all 3 are the same (get it for the first 2) :). Anyway, try using fuzzy tranformations in SSIS and see if that can help you (fuzzy lookup and grouping). MC

Hi MC, We can use the fuzzy transformation but cant connect it with excel we have to extract the data to our table first and then use, but I am not able to get the logic. Thanks

This should get you started: http://msdn.microsoft.com/en-us/library/ms141764.aspx MC