vipin_jha123 (8/5/2015)
Hi When I am trying to execute below command I am getting errorBULK 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.