sorry I dint get ur saying 'have you logged on to the server and checked exactly what that file's name and extension is'.

Both file and sql server are in local only. I went to the the folder and checked ,both are same.

The sql service is running under Network Service. I tried with extensions also:-)

the file is there. I tried with extensions also like sample.csv and all but no luck. I don know whether sa login used is having the permission to read or...

the file is there. I tried with extensions also like sample.csv and all but no luck. I don know whether sa login used is having the permission to read or...

Thanks for replying

bulk insert sample1

from 'D:\BEM_Source\Sample'

with

(

rowterminator = '',

fieldterminator= ','

)