BULK INSERT SQL SERVER 2005
Posted on 2007-10-10
BULK INSERT SQL SERVER 2005:
I'm trying to do the following :
BULK INSERT [HTG_DB].[dbo].[STRATEGY_GROUP]
WITH (FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n');
and am getting the error that the file cannot be found... its there.
Msg 4861, Level 16, State 1, Line 2
Cannot bulk load because the file "C:\Temp\tt.csv" could not be opened. Operating system error code 3(The system cannot find the path specified.).
I remember having this problem a while back but don't remember how to fix it.