also i tried to used the show advance editor andISSORTED as TrueSession_ID 1Line_time 2

but that is not sorting properly hence have choosed the sort transformation option.

currently Source table is completed and showing in GREENSort Transformation is in YELLOWDestination table is still in WHITE

nothing has moved so far

Missed to say one thing

Right clicked on the DFT clicked on PropertiesDefault buffer Max Row as 10000 recordsDefault buffer size changed to 104857600

from 15:54:12till 18:39:00

need help to fix this . please help me.

Regards,Karthik Shankaran (KS)+91-9940074724

Sort tranformation is a fully blocking transform and obviously will cause performance issues especially for large datasets.If your source is database why cant you sort and bring the data from db itself by using ORDER BY in the query? Once you do that you can take advanced editor of the source task and in properties mark IsSorted property as true and set sortkey for columns used in ORDER BY as 1,2 etc in the same order as you've specified them in ORDER BY. Once you do this you can drop the sort transformation altogether and you should get better performance from the package while executing.