Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2011-10-24 : 01:43:39
|
Hi Guys,I am executing my script using the bulk insert but i encounter this error. need your inputs. thanks.Msg 4861, Level 16, State 1, Line 4Cannot bulk load because the file "\\jvltcnos19\hrc-publicdata\22 - LRC Planning Reports\VP309138.csv" could not be opened. Operating system error code 53(The network path was not found.).Regards,JOV |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-10-24 : 02:20:49
|
Make sure that the account has access to that network pathMadhivananFailing to plan is Planning to fail |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2011-10-24 : 02:37:11
|
What if im using SQL 2008 and Windows Authentication to connect? is there any issue on this? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-24 : 03:33:48
|
Does the sql server service account has the access to the path ?PBUH |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-24 : 04:06:14
|
quote: Originally posted by Villanuev What if im using SQL 2008 and Windows Authentication to connect? is there any issue on this?
No issue in that. Only thing is account running should have access to the path------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2011-10-24 : 05:25:55
|
Thank you guys for the input. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-24 : 05:27:32
|
np------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|