In SSIS, I need to avoid duplicate records which was coming form flat file. So what i am doing is, driving output records of flat file to sort transformation, and sorting the records ascending by license id. But i am in speculation that would effect the performance. So i am planning the other way, that is driving the output records of the flat file to the temp table and using the select distinct query. So that i can avoid duplicate records.
So please any one suggest me, which method will effect the performance level.