CODEWITHSUNDEEP
sql-serverssislookup
DraganB
DraganB

Reputation: 1138

SSIS Lookup transformation repeating values

I am trying to retrieve a list of films from excel table and then in the lookup transformation find the missing genres in SQL table and add them. The result should be to add two new genres in SQL table which will automatically be given the id. Problem is that no match up lookup retrieves repeating genres.

My data viewer

Instead of adding just "software" and "the dark side" he add 3 time "software". Can i somehow do distinct in lookup?

Upvotes: 2

Views: 171

Answers (1)

DraganB
DraganB

Reputation: 1138

As @MiguelH posted, using Sort "drop duplicate" facility solved my problem.

Upvotes: 1

Related Questions