I want get table records from DB2 to SQL Server 2000. But I have met a problem that if DB2 table has primary key, but how to save the same table's primary key to the SQL Server 2000 table.
I am now using DTS.
You should create pkey on sql table first then start data copying.
Create it on sql table manually, that's the only way.
But I have a huge volume records need to transfer to SQL Server.
If re-build the primary key, it will not link to foreign key.
thanks......
I will try try.....