true

Thats the design flaw from source system

And I am sure I am getting duplicate row so no need to choose the max row also

I will just use sort with...

the two approach are

do transformation in temp table

or

use dataflow task again to reload staging table after dong transformation on its data and loading it into destination table for...

yes I need the same data

The file wont change

But loading it once and doing transformation not in staging table (so will have to do in temp table) will consume server...

thnks opc

Actually My question is I will be loading the csv int staging right at start as the package need it multiple times

This package is not just ETL but a...