Options
bulk Insert from dat file in sql sever 2017
venkatakesana
Posts: 2 New member
BULK INSERT table FROM 'GI.dat'
WITH ( FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n')
my DAT file containing 6 columns data like below example
IN null null Bank-name 1989 null
ST test yes bank-name 2019 89
while compiling above code I am getting below error message,please send me right code
my DAT file containing 6 columns data like below example
IN null null Bank-name 1989 null
ST test yes bank-name 2019 89
while compiling above code I am getting below error message,please send me right code
Msg 4863, Level 16, State 1, Line 2
Bulk load data conversion error (truncation) for row 1, column 1 (STATE).
Msg 4863, Level 16, State 1, Line 2
Bulk load data conversion error (truncation) for row 2, column 1 (STATE).
Msg 4863, Level 16, State 1, Line 2
Bulk load data conversion error (truncation) for r
Tagged:
Answers