bulk insert RRS feed

  • Question

  • i am tring to bull inset i have txt file in shared foler on my pc and using sql server from server

    file path is EXEC


    ps_StudentList_Import '\\rajender\SharedDocs\txtfile1.txt',1, 1 and geting error is

    Msg 4861, Level 16, State 1, Line 1

    Cannot bulk load because the file "\\rajender\SharedDocs\txtfile1.txt" could not be opened. Operating system error code 5(Access is denied.).

    please help

    Friday, July 10, 2009 1:06 PM


All replies