hi friends
i am trying for bulk insert using SQL server 2000
using this code
bulk insert xyz
from 'D:\authors.txt'
WITH (FIELDTERMINATOR = ',')
but it gve me error saying that
Could not bulk insert because file 'D:\authors.txt' could not be opened. Operating system error code 21(error not found).
i check file security
it has given full control to the file
can any one give me idea about Operating System error code 21(error not found)
thanks
See if you can see the directory/folder contents by using xp_cmdshell 'dir D:\'. Does SQL Server have enough permissions to access the folder?
No comments:
Post a Comment