Date: 01/24/06 (SQL Server)    Keywords: sql

I'm hoping someone knows, because I've been looking on the Internet for the past hour and a half. I have seen this question asked many, many times, but I have no yet seen an answer. sorry if I've asked this exact question before. Maybe someone's new here and knows.

I'm getting the following output:

Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 1, column 10 (underdecis).
Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 2, column 11 (yesno).
Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 3, column 10 (underdecis).
Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 4, column 11 (yesno).
Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 5, column 10 (underdecis).
[etc., etc. ad nauseam]

...from the following command:

bulk insert edi.dbo.hdstaging2 from '\\tesla\sql data\load\hd.txt' with ( DATAFILETYPE = 'char')



Here's the data that corresponds to the above error messages:

HD	030		HLT	NO PREF	FAM		
HD	030		HLT	NO PREF		  
HD	030		HLT	NO PREF		                                   
HD	030		HLT	NO PREF	EMP		                           
HD	030		HLT	NO PREF	FAM		

Source: http://community.livejournal.com/sqlserver/41237.html