bulk Insert from dat file in sql sever 2017

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 April 13, 2019 11:25

Comments

2 comments

please send me right code

venkatakesana April 13, 2019 11:26

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

Russell D April 16, 2019 09:56

0

Add comment

Please sign in to leave a comment.

How can we help you today?

bulk Insert from dat file in sql sever 2017

Comments

Add comment