1. If everything needs to be in a stored procedure, why ask your question in an SSIS forum?

2. No caps. There's no need to shout.

3. Don't use lakhs. This is an international forum. More people will understand your question if you say 500000.

4. I would use a LEFT OUTER JOIN with the history table to find out which rows are updates or not.