Cannot bulk load because the file "\\STI-GGARCIA\C:\sar\anexoa_error.txt" could not be opened. Operating system error code 67(failed to retrieve text for this error. Reason: 15105).

Question

BULK INSERT anexoa_error
FROM '\\STI-GGARCIA\C:\sar\anexoa_error.txt' WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ''
)

alguien me puede ayudar

me manda error

Answer 1

This is an English language forum.

Probably a security issue.

Related threads:

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/7b87d35f-7b08-4727-9544-8dd7035c5e87

http://www.sqlservercentral.com/Forums/Topic840677-148-1.aspx#bm841638

---

Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 2

From the command prompt, run

net helpmsg 67

This explains the error: The network name cannot be found.

This means that the server name or share name is wrong. Looking at your command line, it appears to tbe the latter:

'\\STI-GGARCIA\C:\sar\anexoa_error.txt'

When you refer to a remote disk, you must specify a share name, C: will never work. You can try:

'\\STI-GGARCIA\C$\sar\anexoa_error.txt'

However, in more recent versions of Windows, administrative shares (that is, implicit shares on the root level) are disabled. You may have set up a share explicitly on STI-GGARCIA.

---

Erland Sommarskog, SQL Server MVP, [e-mail]