title: How to import csv file from one linux server to another server(mssql server)
body: <p>I have a csv file in linux server with following data</p>
  
  <pre><code>1,Jared,Australia
  2,Nikita,India
  3,Tom,Germany
  </code></pre>
  
  <p>I have a below table in windows server where mssql present </p>
  
  <pre><code>create table test.test1(Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY, Name NVARCHAR(50), Location NVARCHAR(50))
  GO
  </code></pre>
  
  <p>When I tried importing the csv from linux using sqlcmd it is showing below error.</p>
  
  <pre><code>BULK INSERT test.test1 FROM '10.0.14.23/home/admin/test_bulkinsert.csv' WITH (FIELDTERMINATOR = ',',  ROWTERMINATOR='\n')
  GO
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>Msg 4861, Level 16, State 1, Server STS-PC, Line 1
  Cannot bulk load because the file "10.0.14.23/home/admin/test_bulkinsert.csv" could not be opened. Operating system error code 3(The system cannot find the path specified.)
  </code></pre>
  
  <p>How to import csv file from 10.x.x.x linux server to 10.y.y.y sql sever database table.</p>
  
  <p>Please help me out.</p>
  
  <p>Thanks</p>