Cannot find path error when doing a bulk insert

• jfletcher

  SSC Veteran

  Points: 271

  More actions

  February 14, 2008 at 12:24 pm

  #186607

  BULK INSERT TaxStatementData.dbo.[Test_P_Records]

  FROM 'c:\Tax_Statement_Data\P_Records.txt'

  WITH (FIELDTERMINATOR='|');

  I get an error saying that the system cannot find the path specified.

  The folder exists and the file exists. I copied this from SQL 2000 to SQL 2005. It used to work in 2000. I have 2 experienced guys working on this - I am a complete neophyte - and for days no one has come up with an answer. Please let it be a simple one.

• tbeadle

  SSCommitted

  Points: 1635

  More actions

  February 14, 2008 at 1:13 pm

  #778563

  [font="Arial"]Hello,

  The server is looking for the path on the physical machine it is installed upon. You have probably given a path on the your local machine.

  If you have permission to log on to the server, do that and try the TSQL again.

  Regards,

  Terry[/font]

• jfletcher

  SSC Veteran

  Points: 271

  More actions

  February 14, 2008 at 2:18 pm

  #778590

  Yes, that was my problem. The SQL 2000 that I had was a local installation. I have been informed that I need to have the network gurus give the SQL server access to our network drive so that I can put my files there to load.

  Thank you for the help.