July 25, 2008 at 9:38 am
I am trying to import csv data into a sql server 2005 database but I get the following error - Bulk load data conversion error (truncation) for row 1, column 12 (Draw).
Edit/Delete Message
July 25, 2008 at 9:43 am
Means there's something at that point in the import document that's too big for the field it's going into.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 25, 2008 at 9:52 am
Is there an easy way to identify the actual cause?
July 25, 2008 at 11:42 am
check the data in the file against the schema
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply