How to remove the duplicate value in SSIS?

Step 1: Create OLE DB Source and select the required table from which table you need to delete the duplicate records.

Step 2: By using Sort Transformation we can remove the duplicate record from the table.

Step 3: The below result in you can if you are not selected the option ” Remove rows with duplicate sort values “.

Step 4: After we have selected the option ” Remove rows with duplicate sort values “. The duplicate values will be removed.

Thank You..!