Bulking insert error

• netcloud

  SSC Enthusiast

  Points: 118

  More actions

  October 10, 2018 at 5:07 am

  #380789

  Hello everyone!

  I am new to the forum and I am currently struggling with a bulk insert error.

  The thing is that I want to import bulk data into the server table but it keeps failing into the error mentioned below, I have already tried using .txt and .csv files, but no success on those two.

  Cannot bulk load because the file "‪C:\Users\Shaik\Desktop\Import.csv" could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).

  BULK INSERT PhoneBook
  FROM '‪C:\Users\Shaik\Desktop\Import.csv'
  WITH

  (
  FIELDTERMINATOR = ',',
  ROWTERMINATOR = '\n'
  )
  GO

  I am really kinda lost with this issue and is driviing me crazy, probably its just a simple task to resolve, but as I already said I am clueless, maybe due to me being still a newbie.

  Could you please have a look and try to enlight me with your responses?

  Thank you so much in advance.

  Consultoría de redes de comunicaciones industriales y domésticas.

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  October 10, 2018 at 5:33 am

  #2008783

  Does that file path exist on the server, or on your local machine?

  Here's a quote from the online documentation (the emboldening is mine):

  data_file must specify a valid path from the server on which SQL Server is running. If data_filedata_file is a remote file, specify the Universal Naming Convention (UNC) name. A UNC name has the form \\SystemnameSystemname\ShareNameShareName\PathPath\FileNameFileName. For example, \\SystemX\DiskZ\Sales\update.txt\\SystemX\DiskZ\Sales\update.txt.

  ---