Post reply

Bulk Insert Error

  • November 9, 2007 at 6:28 am

    #376757

    Hi,

    I'm running into this error when trying to do Bulk Insert on Query Analyzer:

    Server: Msg 4861, Level 16, State 1, Line 1

    Could not bulk insert because file '\\ServerName\foldername\foldername\DataFiles\test.txt' could not be opened. Operating system error code 1265(The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you.)

    I believe it's a permission issue, who do I inform about this ; the DBAs or Network Administrators.

    Thanks,

  • November 9, 2007 at 7:38 am

    #749841

    Both...

    The DBA's need to verify that the SQL Server instance is logged in either as a Super User that can see everything or must be logged in as a user that has been granted the necessary privs to the path (which is where the Network Admins may come in).

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply