Thanks for the suggestions. Table is already created and there is data already in the table. But whenever I insert data from now on, i need to see the data...

Thanks for the suggestion. I tried adding identity column to the detination, this is not working. It shuffles the rows and then adds identity column. Data will be sorted in...