troubleshooting Question

sql 2008 insert table - data conversion error (truncation)

Avatar of Amanda Walshaw
Amanda WalshawFlag for Australia asked on
Microsoft SQL Server
7 Comments4 Solutions3628 ViewsLast Modified:
insert issues for sql bulk insert, inserting by csv file
TRUNCATE TABLE dbo.NaturalAccount

BULK

INSERT dbo.NaturalAccount

FROM '\\myserver\myfolder\NATURALACCOUNT.CSV'

WITH

(

FIELDTERMINATOR = ',',

ROWTERMINATOR = '\n',

FIRSTROW=1

)

GO

getting the error
Msg 4863, Level 16, State 1, Line 2
Bulk load data conversion error (truncation) for row 78, column 4 (Account_type).
Msg 4863, Level 16, State 1, Line 2

 
Please find attached error log and csv file I am trying to upload.  It only happens on certain lines and the data is fine.  the column is varchar 3. it will always contain 3 numericals ie 100, 150, 160

I would appreciate your help here.  Please find attached files.
error.txt
NaturalAccount.csv
ASKER CERTIFIED SOLUTION
Habib Pourfard
Senior Software Engineer
Join our community to see this answer!
Unlock 4 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros