Can you please detail the steps how i can do this.

mysource is sqlserver7 and destination is sql2005.

I tried using the Transfer databse task but it has version compatibilty issue.

Thanks,

sh

sorry for the typo.

Given:-

ID--name--code--date

1---abc---A1----01/01/2009

1---xbc---A2----02/01/2009

2---xyz---A3----03/01/2009

2---ayz---A4----04/01/2009

the result should be

ID--name--code--date

1---xbc---A2----02/01/2009

2---ayz---A4----04/01/2009

Thanks

--sh

Thnanks for the reply.But when i try to write the following it gives me error as my server name is with a slash. Can i use ip adress instead of...