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.
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 failednever seen this beforecan you please guide me?REgardsnitin |
|
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 Kizeraka tduggan |
 |
|
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 |
 |
|
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 Kizeraka tduggan |
 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-04-26 : 19:44:10
|
Thanks.I will try thisNitin |
 |
|
|
|
|