For the SQL Buk insert function. Is there a key work to let SQL know that the input data is qualified by double quotes (" ") marks. For example the key work FIELDTERMINATOR tells SQL that each field is terminated by a comma (,) as in the code below.
BULK INSERT [SID].[dbo].[Table]
WITH (FIELDTERMINATOR = ',' ,ROWTERMINATOR = '\n')