Thanks for the reply. We are using SSIS Lookup transformation and OLEDB Command to update the records in the target table.

The Size of the target table is 4o Lakhs currently. It will grow very large in future.