Got another clue! When I am trying the bulk insert locally from my SQL server, the session is using Shared memory as network protocol and the query runs successfully but...

here is the command we are using to bulk insert:

EXEC BULK_INSERT
@TABLE_NAME = 'SAS_MASS_UPLOAD_PF',
@SOURCE_FILE_PATH ='\\gwng-vi.eu1.1corp.org\intern\GIMW\port_upd.csv' ,
@FIRST_ROW =1,
...

@Ed Wagner-- Yes I did execute it yesterday itself and it gave me the output showing the SQL service account and the files which are present in that path. But...

I am having the same issue. I have checked for my SQL service account, it has access to the fileshare and also enabled for delegation after its SPN was set....