Cannot find path error when doing a bulk insert

  • 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.

  • [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]

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply