ssis- creating a unique customer details should have unique entries

• angel41_23

  Old Hand

  Points: 359

  More actions

  March 4, 2009 at 8:01 pm

  #128777

  hi, I am new to SSIS and i need help ...

  Example .....I have 150 tables in a database which has a customer table in it.....

  when the customer comes to the site and fills his information the data is saved in different tables.....

  and we have to export the data into excel sheet such that there should be no duplications if the customer created 2 -3 ids.So, the output should have the customer unique information...

  can anyone help me how to create this logic in SSIS.........

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  March 9, 2009 at 9:28 am

  #956116

  Use Sort task in Data Flow Transformation and check "Remove rows with duplicate sort values" check box in Sort Transformation Editor.

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers