Posted by ckirby on 12/27/05 20:40

After a bit of reading on bcp, it appears that Bulk Insert is a good
fit for what I am trying to accomplish (and I can run it through
T-SQL!!)
But I'm getting an error that seems to indicate that the OS can't find
the file.

Here's the code I'm using:
BULK INSERT dbo.tmpPaTimeClock FROM 'C:\Program Files\Traverse
CWIN\PER_HRS1.CSV'
Error :
Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because file 'C:\Program Files\Traverse
CWIN\PER_HRS1.CSV' could not be opened. Operating system error code
3(The system cannot find the path specified.).


That path is on my local machine.. Does Bulk Insert operate from the
Server box, so the path I enter has to be a path to a folder on the
machine where the SQL Server is running?

[Back to original message]