BULK INSERT syntax error
Looking at the BULK INSERT documentation, it shows that the syntax should be:

BULK INSERT Table_name
FROM 'FilePath'
WITH 
( FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n')
;  


ie, with = signs between the option name and the value.