471,076 Members | 1,264 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,076 software developers and data experts.

Problem Copying Table

I am trying to copy a table to another SQL 2000 Database, but I
continually get errors.

When I right-click, choose All-Tasks, Export-Data and go through the
DTS settings, I get an 'Unspecified Error' on row 107 (which, looking
at all visible data, there appears to be no difference than the 100
rows before it).

Failed: Copying to a different database.
Failed: Copying to the Same database with a different table name.
Succeeded: Exporting to a Text file (not helpful however)

Different tables copy just fine.
The design is a primary key (integer, auto incrementing), 10 text
fields and another integer field.

Has anyone ever run into this silly/unhelpful error message before?

Oct 3 '06 #1
0 1441

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Google Mike | last post: by
reply views Thread by RJS | last post: by
9 posts views Thread by Zoo Keeper | last post: by
6 posts views Thread by Club-B42 | last post: by
20 posts views Thread by ongaro.admin | last post: by
2 posts views Thread by Neil | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.