CODEWITHSUNDEEP
sql-serverssis
Eric Mbiada
Eric Mbiada

Reputation: 133

Stop duplication data to be input in excel destination using SSIS 2015

The package attached worked fine and all rows are inserted. what I am trying to do now is if a new data is added into the excel source and I run the package again only the new row is inserted into my excel destination. Thanks for your help

enter image description here

Upvotes: 0

Views: 150

Answers (1)

Chris Mack
Chris Mack

Reputation: 5208

You could use a Merge Join component with a Left Outer Join. The left part is your data, and the right part would be your Excel Destination.

If you join on the columns you want to be unique, and capture one of your join columns (from then Excel Destination) in the output, there will be NULLs in that field where no match is found. You could then use a Conditional Split to pass only these rows, i.e. where the join column is NULL, to the Excel Destination.

Upvotes: 1

Related Questions