'Bulk Insert SQL Server FROM network file

Can't seem to get this bulk insert to work. I know the SQL Server windows account has appropriate permissions to this network folder - that has been verified.

The error I get is: Msg 12704, Level 16, State 1, Line 1 Bad or inaccessible location specified in external data source "(null)".

I can copy and paste the path into my windows finder and it opens the file but maybe I am using the wrong syntax in the SQL statement?

Here is the SQL statement:

BULK INSERT Employee_be.dbo.Table_Cur_Test
FROM '\\SERVERPATH\Data\Test\CurTest.txt' 
WITH    
(   
    FIELDTERMINATOR = ',',  
    ROWTERMINATOR = ';\n'   
) 

GO

Any suggestions?

sql-server bulkinsert

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Bulk Insert SQL Server FROM network file

Sources

Related Questions