Software

Ask something
Discussion Locked

SQL Server 2000 Import Data Fails

0 helpful
8 replies

by dawood

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm attempting to Import data from SQL Server 2000 to another and the copy always fails while Copying SQL Server Objects. The error message is pretty useless - [SQL-DMO] The Bulk Copy execution failed. I'm using the Import Wizard when doing this.Any ideas on what might be causing this error?

8 replies

by dawood

The error message [SQL-DMO] The Bulk Copy execution failed, is the entire message. There is nothing else that SQL reports that I can find.

by neonash

You can try "Restore" option in Enterprise manager instead of "import". It may help you. Just a thought. Make sure you pick "Force restore" and the database name is right.

by dawood

I'm trying to build a copy of the DB in question on a test server. I've not backed up the DB in question on the test server so restoring is not an option. I don't think. I'm not a MS SQL god and there might be another way to do what I want.

by neonash

Either you have not explained the scenario correct or you do not know what you want. Good luck!

This discussion is closed to new replies.