Hi Vipin

I'm not sure that it is possible, you could try add a asynchronous transformation such as a sort to your "task 3" pipeline, this will force the process to hold of on continuing until the last record has arrived. this is not a great solution though as it will consume more of you buffers making everything slower.

Instead what you might try is to write those records to a staging table and then copying them into the main table with an execute SQL task or data flow task once task 1 has completed.