removing/redirecting duplicates in ssis

• siri_rmsi

  Old Hand

  Points: 348

  More actions

  November 5, 2014 at 4:49 am

  #298198

  how to remove/redirect duplicates in ssis

  case-

  columns: id, name, address, phone

  id is same but name and other columns are different

  like... (1,abc,twr,12345),(2,abc,twr,12345),(3,abc,twr,12345)

  how to deal with such situation

  ,:w00t:

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  November 5, 2014 at 5:05 am

  #1756711

  Can you explain a bit more what you are trying to achieve?

  Btw, your sample data has different IDs and all the other columns are the same.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP