Thanks Jeff for your reply. As you have mentioned, this method hits the performance very badly. Is there any other way of doing it?

Hi,

I have tried out this. I still observed truncate\insert is much faster that incremental load using MD5 process. For 800000 records, truncate\insert took 33sec to load while incremental process took...

As per my knowledge we can dynamically change the connection strings using Configuration(.Config) files.