Buld insert error
-
Hi,
Sorry about double post but i think previous post was at wrong place.
i am trying to use bulk insert first time. I need data from csv to sql table. it gives some error.
annot bulk load because the file "\\\wcl\Extracts\Executive\2008-12-19.csv" could not be opened. Operating system error code 5(Access is denied.).
I do have read permission on csv and i can open the file. Do i need full permission on csv? i dont think so.
I am member of sysadmin.
Can you please advice?
thanks,
vijay
-
Can you try giving full permissions to the file? Another issue might be if another process has opened the file in non-share mode.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
I tried but it didnt work. thanks for your help.
-
So your problem is not permissions problem, but a problem of the file being accessed simultaneously from another process.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
It is not access by another process or used by other process. I took copy of the file and put it to different location with different names and tried but it says file could not be opened. and Access denied.
-
Did you try to read the file from a local hard drive? Also did you try creating mapping to this network share and then using the mapping instead? This error might be misleading.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
i have tried to write data into files and it allows to write data...bt dont run with read data....
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply