I've tried using DTS to copy my database tables from one database to another:
by clicking on "All Tasks", then "Export Data". For most tables, they were
successful, but for 9 of them, I always received this error (the row number
is different for different errors):

Error at Destination for Row number 81. Errors encountered so far in this
task: 1. Unspecified error

I've tried re-installing my MS SQL Server 2000 software but the problem
still persists. Regardless of which test servers I try these 9 tables on, the
same error always appears. However, I tried on my colleague's PC, and his
can do the transfer successfully. Please help, thanks!

Ok for the tables that fail can you build a datapump task for them instead of using the wizard. Make sure you enable logging at
both the task and package level.

This may give us more info

Is your colleague's PC set up the same, same DB - same DB?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Lena Tay" <Lena Tay (AT) discussions (DOT) microsoft.com> wrote

Yes, my colleague's PC set up is exactly the same as mine.

"Allan Mitchell" wrote: