1

I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is the query:

BULK INSERT [kf].myTable
from '/Users/username/path/to/file.csv'
with(
    FIELDTERMINATOR = '\t',
    ROWTERMINATOR = '\n'
)

The error I am getting is:

Msg 103010, Level 16, State 1, Line 1
Parse error at line: 1, column: 1: Incorrect syntax near 'BULK'

I've looked at other suggestions and none of them have worked. Is it possible that BULK is just not supported by Azure Data Studio?

Tom V
  • 15,752
  • 7
  • 66
  • 87
ITried
  • 111
  • 1
  • 2

0 Answers0