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 |
|
rongrzywacz
Yak Posting Veteran
57 Posts |
 Posted - 2002-01-05 : 22:25:30
|
| Running the same bcp bulk load statement with the same data, that I run in SQL server 7.0 gives me the following error in 2000. Server: Msg 4863, Level 16, State 1, Line 1Bulk insert data conversion error (truncation) for row 1, column 1 (MemNum). the format statement is 1 SQLCHAR 0 11 "" 1 memnum. Thanks for any help.Ron Grzywacz |
|
|
rongrzywacz
Yak Posting Veteran
57 Posts |
Posted - 2002-01-05 : 23:16:31
|
| Sorry it is not a BCP statement but a bulk insert, from query analyzer.Ron Grzywacz |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-06 : 07:35:21
|
| Looks , from you error your are trying to insert a character value in a numeric column. the problem is in from your first row itself from the file where you are trying to insert.Check it again, the corresponding columns ,values and their datatypes. HTH----------------------------Anything that Doesn't Kills you Makes you StrongerEdited by - Nazim on 01/06/2002 08:31:58 |
|
|
|
rongrzywacz
Yak Posting Veteran
57 Posts |
Posted - 2002-01-09 : 10:55:22
|
| No the field is defined as an nvarchar (12). If I change it to varchar it works Ok. I don't own the db so I am not at liberty to change the datatypes. Thanks for any input.RGRon Grzywacz |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-01-09 : 16:50:42
|
| Look in BOL under "File Storage Type". The proper format type for nvarchar is SQLNCHAR not SQLCHAR. You will have to modify your format file to match the new datatypes.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
BCP error in sql 2000