Post reply

regd bulk insert

  • March 13, 2008 at 1:06 pm

    #124444

    i have a flat file from which i m trying to bulk ineert into a table in a datbase using ssis....i have given the conneciton and the path of the source file n the table i got an error saying

    could not be opened. Operating system error code 5(Access is denied.).".

    but i have set the access to full and we have all the files in other server so i have put them in network folders and accessed by logggin in when askes for username and password and gave the path but i culdnt do that is there anyway i could do that to run ...plz let me know thkz in adavcne

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • March 13, 2008 at 1:35 pm

    #789288

    Could you try giving full access to that network share for your user id.

    --------------------------------------------------------------------------------------
    Save our world, its all we have! A must watch video Pale Blue Dot[/url]

  • March 13, 2008 at 1:47 pm

    #789303

    i tried doing it opened the properties of the folder and clicked on security set the users to full access n tried but it didnt worked out i dnt know why ??/

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

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

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