Thanks again Koen!! The package is a loading data from oracle to SQL server from 5 tables with each table of 200,000 size approx. Using Oledb providers. The 5 queries are in 5 Data Flow which are executing parallel. This used to take around 2 to 3 hrs and now it is taking around 8hrs.

Your suggestion on what are the parameters I should check will greatly help!!

Attunity we are not able to use as of now, but will plan in future..