bulk Insert from dat file in sql sever 2017

venkatakesana

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

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

venkatakesana

please send me right code

Russell D

You're probably better off asking this over on https://sqlservercentral.com/ as it's more suited to SQL enquiries.