Friday, February 24, 2012

bulk insert

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