bpfsr
asked on
Error message with bulk load in SQL Server 2005 - Msg 4863, Level 16, State 1, Line 1
I am trying to bulk load data into sql server 2005, I have set up using the following query:
create table BookitTest
(
SKU varchar (15),
ISBN varchar (10),
Title varchar (150),
Condition varchar (25)
)
BULK INSERT BookitTest
FROM 'C:\My Documents\Softbyte Files\3729638.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
and I am getting the following error message:
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 2, column 4 (Condition).
Any ideas how to fix this?
create table BookitTest
(
SKU varchar (15),
ISBN varchar (10),
Title varchar (150),
Condition varchar (25)
)
BULK INSERT BookitTest
FROM 'C:\My Documents\Softbyte Files\3729638.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
and I am getting the following error message:
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 2, column 4 (Condition).
Any ideas how to fix this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It occurred to me "condition" might be a reserved term so I changed the name of the column and changed the length of the varchar and it did work, thanks.
the list of reserved keywords in sql 2000 and 2005:
http://msdn.microsoft.com/en-us/library/aa238507(SQL.80).aspx
http://msdn.microsoft.com/en-us/library/ms189822.aspx
"condition" is not in the list...
http://msdn.microsoft.com/en-us/library/aa238507(SQL.80).aspx
http://msdn.microsoft.com/en-us/library/ms189822.aspx
"condition" is not in the list...
ASKER