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).
Friday, February 22, 2013 8:35 PM
BULK INSERT anexoa_error
FROM '\\STI-GGARCIA\C:\sar\anexoa_error.txt' WITH
FIELDTERMINATOR = ',',
ROWTERMINATOR = ''
alguien me puede ayudar
me manda error
- Edited by GilbertoGarcia Friday, February 22, 2013 8:39 PM
Friday, February 22, 2013 8:44 PMModerator
This is an English language forum.
Probably a security issue.
Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
- Edited by Kalman TothMicrosoft Community Contributor, Moderator Friday, February 22, 2013 8:45 PM
Friday, February 22, 2013 10:49 PM
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:
When you refer to a remote disk, you must specify a share name, C: will never work. You can try:
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, firstname.lastname@example.org