February 14, 2008 at 12:24 pm
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.
February 14, 2008 at 1:13 pm
[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]
February 14, 2008 at 2:18 pm
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