sql - Rank/Rownumber function in SSIS Dataflow -
In my dataflow, after some lookup I'll get duplicate customer records (they are not exact duplicates, only customer ID), Based on some characteristics of customers like the city, location. I have to choose a record between them. How can I get it into an SSIS database? Here is sample data: ; (Customer ID, cutomer_name, score) (select 1 as the Customer ID, select 'ABC' as cutomer_name, score union as 100, 1 'ABD', tap union selection 1, 'ABD ', 20) Select * From Customer From here I have to select the record with the lowest score and only send that line to the last line. It is easy to get it from the Rumah Festival in SQL, but this case occurs during the dataflow in SSIS Enter the source data access mode on the SQL command.