• vipin_jha123 (8/5/2015)


    Hi When I am trying to execute below command I am getting error

    BULK INSERT ##MD_GEOGRAPHYLEVELTYPE

    FROM 'H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELTYPE_US.txt'

    WITH ( FIELDTERMINATOR =',', FIRSTROW = 9 )

    error

    Msg 4861, Level 16, State 1, Line 1

    Cannot bulk load because the file "H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELTYPE_US.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).

    make sure that sql server service account have access to this path.