ssis - how to remove duplicate record

Question

I want to load the data from excel into table, the table with 2 column, ID and name

how to remove the duplicate record ID+NAME by ssis

Answer 1

Hi @nononame2021 ,

Note that you have post several issues on Q&A, if the resolution is helpful, please Mark it as Answer so other user with similar problem could see this easier.

This behavior could also encourage our experts to offer more help.

To remove duplicates Rows, you may use Sort Transformation.

Here is a detailed tutorial you may take a reference.

removing-duplicates-rows-with-ssis-sort-transformation

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.