I tried the following code to try and bulk load into a table in my SQL Server.
BULK INSERT dbo.CentralRepository_Associate_Details
FROM '/1CAAP/1413/data/csvtest1.csv' WITH (FIELDTERMINATOR = ';')
and got the following error :
Cannot bulk load because the file "/1CAAP/1413/data/csvtest1.csv"
could not be opened.
Operating system error code 3(failed to retrieve text for this error. Reason: 15105).
I guess error code 3 is a permission error.
Just a request: I'm not very good as far as stuff like this is concerned. So explanation in layman terms would be really helpful.
C:\Files\FileName.CSV
and you are also missing theROWTERMINATOR
clause of your bulk insert.\\ServerName\Folder\FileName.CSV
, Just make use Your login has permissions on that Network Share. and correct your synatx for bulk insert, as you are missingROWTERMINATOR
clause of your bulk insert statement.