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 |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2005-07-08 : 15:46:22
|
| Hello, I am not sure if any one has enountered this problem. I used BCP to copy data, the source has 19 million rows and BCP copied only 18 million rows to destination table. Has any one had this issues before, please let me know if there is any solution.Thanks,Sridhar |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-07-09 : 13:53:21
|
| Probably somehing wrong with the format ofthe file. bcp will use the following row to fill in data if it doesn't have enough in a row. If there are no datatype problems with this it won't give an error.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-10 : 17:18:19
|
| Have you tried creating an error file with the -e switch?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2005-07-12 : 18:33:14
|
| Thanks for reply guys.Nr,Actually, i am thinking the format file should be ok. Because i am getting bcp'd less row when the table is huge and when i try to bcp out a table which 1 or 2 million works fine.there are no errors in -e Error file. I am thinking if the table data has been corrupted or what?I ran DBCC commands to find out, but every thing looks ok except for 1 table iget table corrupted error. Please advice me if you guys had come accross this situation.Thanks,Sridhar |
|
|
|
|
|
|
BCP copied less rows