SSIS 2017 :- How to remove duplicate records using SSIS package

In this post, I am going to remove the duplicates rows of the below table.

Step1 :- Drag and drop the Data Flow task to Control Flow.

Step 2:- Create a connection manager to conenct databse and test the connection

Step 3:- Double click on the Data flow task. Drag and drop the OLE DB Source to link the source table

Step 4:- Select The connection manager and source table.

Step 5:- Drag and drop the Sort componant and lisnk with OLE DB Source

Step 6:- Specify the colimn to sort from the source table

Step 7:- Drag and drop the OLE DB destination and link with Sort componant.

Step 8:- Go to mapping tab and link with columns of the destination table.

Step 9:- Save and Execute the package.

Step 10:- GO to the  table and write below script to view the data of the destination table.

Thank You !!!!