0

I'm trying to import the CSV file values using bulk insert but I'm getting an error in my code.

Can anyone help me with this?

The following is the code I wrote:

SET NOCOUNT ON 

BULK INSERT JBLOADER.dbo.FBNK_TELLER 
FROM "\\Karthick\c\sql\FBNK_TELLER_4_0.csv"
WITH
(
     CODEPAGE = 1251,
     FIELDTERMINATOR = '?',
     ROWTERMINATOR = '0x0a'
)
GO

SELECT CONVERT(varchar,@@ROWCOUNT) + ' rows affected'
GO

And I am getting an error:

Msg 4860, Level 16, State 1, Line 2
Cannot bulk load. The file "\Karthick\c\sql\FBNK_TELLER_4_0.csv" does not exist.

But I can access the path \\Karthick\c\sql\ from run mode & the file is there. Kindly note that server is installed on the same machine.

Can someone help me solve this?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Karthick88it
  • 601
  • 2
  • 12
  • 28
  • try to map that folder and see how it goes. – FLICKER Apr 13 '16 at 04:11
  • I have already mapped the folder & the same problem persist again.. – Karthick88it Apr 13 '16 at 04:20
  • Possible duplicate of [BULK insert error with UNC path and windows Authentication](http://stackoverflow.com/questions/852117/bulk-insert-error-with-unc-path-and-windows-authentication) – TomTom Apr 13 '16 at 04:41
  • Let's close it. It is a user stackexchange error (not bothering to search) and a double of http://stackoverflow.com/questions/852117/bulk-insert-error-with-unc-path-and-windows-authentication – TomTom Apr 13 '16 at 04:41

0 Answers0