Reading CSV files located on LINUX server and updating the tables in SQL Server Database
I think there are at least two generic options for this kind of thing:


have a network share that the SQL Server host can connect to on the Linux server.
sync the file from Linux server to the DB host (by e.g. using a network share on the DB host, or any other way of copying files over network).


Remark: The way Windows handles mapped network drives, it might be that the login session running the DB processes would not see the drive if it was mapped by some other user account. Thus the first option is preferred (maybe also from the pov of dbas?).