none
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

    Friday, February 22, 2013 8:35 PM

Answers

  • 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, esquel@sommarskog.se
    Friday, February 22, 2013 10:49 PM

All replies