insert multiple insert using openrowset

  • Hello,

    I am trying to update column using this query:

    update BIOGRAPH_MASTER set UDEF_1A_1=(select bulkColumn from openrowset(bulk 'mdrive\jenzabar2\images\4359099.JPG',single_blob) as x) ;

    and I get following error:

    Msg 4861, Level 16, State 1, Line 1

    Cannot bulk load because the file "mdrive\jenzabar2\images\4359099.JPG" could not be opened. Operating system error code 3(The system cannot find the path specified.).

    How can I update udef_1_A column??

  • OS errors are typically permission or path errors.

    This isn't about SQL, this is the service not being able to find/open the file itself.

  • In addition to Steve's reply: you have to understand that the query runs on the server, not on your workstation. That may impact the interpretation of the path.

    Also, the file is accessed by the SQL Server service account, not by you. So check that the service account has permissions.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

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

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