Skip to main content
Database Administrators

Return to Question

[Edit removed during grace period]
Link
Edison
Edison
  • 151
  • 1
  • 6
added 1 character in body
Source Link
Edison
Edison
  • 151
  • 1
  • 6

I am running SQL Server from a Docker container on macOS. EverythingAll queries except for the loading of the csv file is getting executed. The column names etc are correct. Any ideas?

error:

Cannot bulk load. The file "/Users/me/snp500-company-by-sector.csv" does not exist or you don't have file access rights.

bulk insert CompanyBySector
from '/Users/me/snp500-company-by-sector.csv'
with
(   
    firstrow = 2,
    fieldterminator = ';',
    rowterminator = '\n',
    tablock
)
go

I am running SQL Server from a Docker container on macOS. Everything except for the loading of the csv file is getting executed. The column names etc are correct. Any ideas?

error:

Cannot bulk load. The file "/Users/me/snp500-company-by-sector.csv" does not exist or you don't have file access rights.

bulk insert CompanyBySector
from '/Users/me/snp500-company-by-sector.csv'
with
(   
    firstrow = 2,
    fieldterminator = ';',
    rowterminator = '\n',
    tablock
)
go

I am running SQL Server from a Docker container on macOS. All queries except for the loading of the csv file is getting executed. The column names etc are correct. Any ideas?

error:

Cannot bulk load. The file "/Users/me/snp500-company-by-sector.csv" does not exist or you don't have file access rights.

bulk insert CompanyBySector
from '/Users/me/snp500-company-by-sector.csv'
with
(   
    firstrow = 2,
    fieldterminator = ';',
    rowterminator = '\n',
    tablock
)
go
Source Link
Edison
Edison
  • 151
  • 1
  • 6

(macOS/Docker) "Cannot bulk load. The file path does not exist or you don't have file access rights."

I am running SQL Server from a Docker container on macOS. Everything except for the loading of the csv file is getting executed. The column names etc are correct. Any ideas?

error:

Cannot bulk load. The file "/Users/me/snp500-company-by-sector.csv" does not exist or you don't have file access rights.

bulk insert CompanyBySector
from '/Users/me/snp500-company-by-sector.csv'
with
(   
    firstrow = 2,
    fieldterminator = ';',
    rowterminator = '\n',
    tablock
)
go