Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 bulk copy failed

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-04-26 : 13:46:50
I am trying to export 3 tables from local to export and getting this error.
Bulk copy failed
never seen this before
can you please guide me?
REgards
nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-26 : 13:49:30
You haven't provided enough information for us to assist you. Please post the actual command that is causing the error and perhaps a few rows from your file. Does the file exist on the database server or on your client?

Tara Kizer
aka tduggan
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-04-26 : 14:02:38
I am trying to export 3 tables from my local server to the client server.I am using DTS export /import wizard.Thatz it.
Please help
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-26 : 14:05:14
We don't have enough information to help you. "Bulk copy failed" doesn't give enough information to help us troubleshoot it for you. It is too generic of an error. I would suggest creating the destination tables using scripts instead of letting the DTS wizard do it for you. Once you've done that, then you just need to move the data, making sure to select the already created tables in the wizard.

Tara Kizer
aka tduggan
Go to Top of Page

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-04-26 : 19:44:10
Thanks.I will try this
Nitin
Go to Top of Page
   

- Advertisement -