Tag Archives: merge

UPSERT in SSIS

I had a work on a quick delivery which involves UPSET using SSIS, following is refresh! What is UPSERT in typical scenario? When I have to insert records into destination if the record does not exist and/or update multiple values … Continue reading

Posted in Productivity, SQL, SSIS | Tagged , , , , | Leave a comment

SQL Data Compare Tool

Last week, I was working on merging the data (multiple tables) between 2 SQL Servers, I had to analyze number of rows which are identical on both Server, which are only in one of the Server and which are different. … Continue reading

Posted in Productivity, SQL | Tagged , , , , , | Leave a comment