>>Hi,
>>
>>BULK INSERT LLNET.dbo.ProductColumnTypes
>>FROM 'C:\Test.Txt'
>>WITH (DATAFILETYPE='char')
>>
>>Running 'Verify SQL Syntax' against the above gives 'Cannot bulk load. The file "C:\Test.Txt" does not exist'. It does. What might be the real problem?
>>(This is actually in SQL 2005 Express)
>>TIA,
>>Viv
>
>It depends where is that C:, it must be on the computer where SQL Server is installed, not on your local computer.
In this case they are the same - i.e. the file is on the same machine as the SQL Server.
FWIW using bcp on the same table and file works...
UPDATE:
Oops. You were right. I had another server (on a different machine) with the same database listed in the Management Studio and it was trying to execute against that. Thanks for pointing me in the right direction,
Best,
Viv