Home Bulk insert from file thrown an error Cannot bulk load because the file could not be opened
Reply: 0

Bulk insert from file thrown an error Cannot bulk load because the file could not be opened

user782
1#
user782 Published in June 19, 2018, 6:16 pm

I'm working with remote Microsoft SQL Server.

After executing following code using DataGrip on Ubuntu I receive an error:

CREATE TABLE #TempNullClass (
  id          nvarchar(10),
  classCode   nvarchar(10)
);

BULK INSERT #TempNullClass
FROM '/home/user/Downloads/data1.csv'
  WITH (
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '0x0a'
  );

[S0001][4861] Cannot bulk load because the file "/home/user/Downloads/data1.csv" could not be opened. Operating system error code 3(The system cannot find the path specified.).

File has all of the permissions:

-rwxrwxrwx 1 user user      73399 may 15 15:11 data1.csv

I cannot put the file on remote server.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.313218 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO