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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Bulk Insert

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, FIELD

I 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/
Go to Top of Page

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)''.
Go to Top of Page
   

- Advertisement -