I export all tables from serverA databaseAA to serverB (both SQL2k sp3)databaseAA with 'Success', but without any relationships. In SQL6.5 Tools of Transfer will bring all objects include relationship.
I also tried export "All Objects" which fails with unclear message. I just don't want to do a backup and restore....
Did you use default options (which copies primary and foreign keys).
If foreign keys are not getting transferred you can generate table schema script and grab foreign keys script from there and recreate them in target server.
After set up the DTS error log, here is the errors(it does not help much):
(it is a simple Copy SQL Objects Task)
Step Error Source: Microsoft SQL-DMO
Step Error Description:[SQL-DMO]Unexpected parameter value or other condition.
Step Error code: 80045339
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1132
I had upgraded my copy source SQL2k from SP2 to SP3 with MDAC reinstalled and checked copy Target server is sp3 already.
Attached is the detail error .txt.