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?

Improve this question
4
  • Not that it solves your MAC issue, but I downloaded the Windows version of SQL Operations Studio and had no problems using your basic BULK INSERT command against a test table of mine.
    – Scott Hodgin - Retired
    Jan 5, 2018 at 21:43
  • ok. Is the file you are inserting local? and db remote? If yes, then maybe I can just use a windows computer instead to insert
    – ITried
    Jan 6, 2018 at 0:21
  • Did you copy paste? any chance of weird characters in there?
    – Nick.Mc
    Jan 6, 2018 at 12:33
  • Ive tried both copypaste and write from scratch. Same error. Any chance this has to do with the fact that the file to insert is stored in different location that db?
    – ITried
    Jan 6, 2018 at 20:59

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.