Why can't bulk insert format csv?

Question

I have this code: BULK INSERT [custdb].[dbo].[TB_T_DISP_PARTY] FROM 'd\DB\dbo.TB_T_DISP_PARTY.csv' WITH ( FIRSTROW = 2, FORMAT = 'CSV' );

And then I get this error

'Msg 102, Level 15, State 1, Line 6 Incorrect syntax near'FORMAT'.'

Can somebody tell me how to fix this error?

FORMAT only works on SQL 2017 and higher. What version are you running? — JMabee
– JMabee, Commented Jul 1, 2020 at 10:07

K Viswagna · Accepted Answer · 2020-07-01 12:05:17Z

1

It is just bcoz of Version Difference

FORMAT = 'CSV' Applies to: SQL Server 2017 + Versions

answered Jul 1, 2020 at 10:17

K Viswagna

995 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I tried to copy the correct path, but still can't run.