locked
Problem on Bulk inster from network drive RRS feed

  • Question

  • Problem on Bulk inster from network drive

    My script is as below:

    BULK INSERT trd_test  
      FROM '\\192.168.20.81\trdtmp\test.txt'
      WITH  
      (  
      FIELDTERMINATOR ='~',  
      ROWTERMINATOR = '\n', 
      FIRSTROW = 1  
      ) 

    At the time of Bulk instertion from network drive following error come out:

    "Msg 4861, Level 16, State 1, Line 2
    Cannot bulk load because the file "\\192.168.20.81\trdtmp\test.txt"
    could not be opened. Operating system error code 5(Access is denied.)."


    Ahsan Kabir

    Tuesday, August 7, 2012 7:28 AM

Answers

All replies