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 |
|
marcusn25
Yak Posting Veteran
56 Posts |
 Posted - 2014-10-02 : 10:03:40
|
| CREATE TABLE #TestTable( [Surname] [nvarchar](MAX) , [PostCode] [nvarchar](MAX) ,)GO BULK INSERT #TestTable FROM '\\rootpath\filname.csv'WITH (FIRSTROW = 1, FIELDI am using the above statement to do a bulk insert from a shared drive but I am getting the following error.Cannot bulk load because the file "\\rootpath\filname.csv'" could not be opened. Operating system error code 3(error not found).Check list? I am using domain account.? I have the Bulk admin Server role in SQL Server? I have access to the root path? I can bulk load from the local path ‘'C:\Data\filname.csv"'’ buts that’s not the requirement.Any ideas please, I am stuck on this?Marcus I learn something new everyday. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-10-02 : 10:30:58
|
| You have to enable constrained delegation for your SQL Server service account. See if this article will help you. http://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/ |
 |
|
|
marcusn25
Yak Posting Veteran
56 Posts |
Posted - 2014-10-02 : 10:50:45
|
| I will try but my error does not say 'access denied'.''Cannot bulk load because the file "\\rootpath\filname.csv'" could not be opened. Operating system error code 5(error not found)''. |
|
|
|
|
|
|
Bulk Insert