Pubudu Dewagama

SQL MERGE Query to Insert, Update and delete records in the destination table

In the Data warhousing application, we have to update Data warehouse according to the source data. In the SQL Server wecan use the Merge qu...

SQL MERGE Query to Insert, Update and delete records in the destination table

Reviewed by Pubudu Dewagama on 10:37:00 PM Rating: 5

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. S...

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

Reviewed by Pubudu Dewagama on 9:25:00 PM Rating: 5