Thanks Anith, I have tried that, but get the message "Failed to copy
objects from MS SQL to Server to MS SQL Server" and "MS ODBC SQL Server
Drive [SQL Server] The login 'login name for local server' does not
exist." The table structure is imported but without the primary key and
none of the data.

If I choose the first option in DTS "Copy tables and views..." - the
table structure and all data is imported successfully but WITHOUT the
primary key.