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 |
|
rizo
Starting Member
16 Posts |
 Posted - 2013-04-12 : 11:16:06
|
| Hi All,I am getting the following error when I run a BulkUploadMsg 4867, Level 16, State 1, Line 1Bulk load data conversion error (overflow) for row 1, column 1 (pResultsID).My FMT File contains the below9.081 SQLINT 0 10 "," 1 pResultsID ""2 SQLINT 0 10 "," 2 PollID ""3 SQLINT 0 10 "," 3 QID ""4 SQLINT 0 10 "," 4 RespID ""5 SQLINT 0 10 "," 5 FirmID ""6 SQLINT 0 10 "," 6 AnswerID ""7 SQLFLT8 0 255 "," 7 Answer ""8 SQLCHAR 0 255 "\n" 8 pResultsDate Latin1_General_CI_AIand the data is9784903,10,71,99908,NULL,9,0,2012-04-21 08:47:00Any ligh on this would be appriciated.thanksrizo |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-12 : 13:11:09
|
| Your format file and the data file looks right. The datalength column should be 4 for sqlint and 8 for sqlflt8, but that should not really cause the error. I assume the fields in the format file are tab separated as they should be.You might try couple of things:1. Generate a format file to import all the fields as SQLCHAR of appropriate length to see if that fixes the problem.2. Generate an xml format file rather than the tab-delimited. I always have trouble with the tab-delimited files, and have found xml files to be easier to work with. |
 |
|
|
|
|
|
|
|
Msg 486