Bulk Insert - Local Data Files

• Jan Sorenson

  Mr or Mrs. 500

  Points: 579

  More actions

  June 28, 2010 at 1:27 pm

  #223339

  When using the T-SQL Bulk insert command from SQL Server Management Stuidio, how does one reference a file on his local machine as opposed to a file on the sql server. I am getting the error "Cannot bulk load. The file "C:\3005PAIDS.txt" does not exist" and expect that the system is looking for the file on the server. Is there a way to use the bulk insert command and reference a data file on my local machine?

• spaghettidba

  SSC Guru

  Points: 105712

  More actions

  June 29, 2010 at 1:52 am

  #1186209

  Use UNC paths:

  \\yourcomputername\sharename\filename.csv

  Bulk inserts use delegation, so make sure your share can be accessed by the user that performs the BULK INSERT command in SQL Server.

  -- Gianluca Sartori