Could not bulk insert

[Guvera]

Could not bulk insert because file 'C:\csv\name.txt' could not be opened. Operating system error code 3(The system cannot find the path specified.).

I got the above error.

CREATE TABLE checkcsv
(
col1 varchar(100),
col2 varchar(100)
)

BULK INSERT dbo.checkcsv
FROM '\\IWAPPSVR\IWSQLDB\csv\name.txt'
WITH
(FIELDTERMINATOR = ',', ROWTERMINATOR = '/n')

I got the error and i couldnt solve this.solve the query please.

Hope yours reply.

[kevchadders]

As the BULK INSERT is executing on the Server have you verified that the Server can actually connect to your PC and view your csv folder on your C drive?

What i would do is log onto the server and open windows explorer, then try to browse to your folder from there.

Also right click on the CSV folder and check the security setting to make sure the SQL Server account can access your PC.