Post reply

Bulk Insert Error

  • May 17, 2007 at 3:59 am

    #62503

    Hi friends..

    I am facing a problem about Bulk Insert.

    when I give a command for bulk insert on server and file is on the same server the bulk insert is running successfully.

    but same command is given with the file is on the other machine then its showing the

    Could not bulk insert because file '\\172.16.4.80\OT Files\hdf0307.txt' could not be opened. Operating system error code 5(Access is denied.).

    its very urgent....

    Paritosh

     

     

  • May 18, 2007 at 6:23 am

    #707396

    \\172.16.4.80\OT Files\hdf0307.txt

     

    try to have the name of the folder of 'OT Files' without spaces and try.. like 'OTFiles'

  • May 18, 2007 at 6:53 am

    #707416

    Check that the SQL server and SQL Server Agent service is running under a domain logon account. If it is running as the default 'local system' account on the server then it won't be able to access shares on other servers.

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

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