As records are in comma separated so you can SSIS packages to load the data in you destination table. But make sure for "COL2_SALES" in your raw file should be two values separated with commas.

One more approach: 


create table data (COL1_OPERATOR varchar(20),COL1_SALES1 varchar(20),
COL2_SALES2 varchar(20),
 PROMO_ID varchar(20))

bulk insert data from 'C:\SSISLoad\Data.txt'
with( DATAFILETYPE = 'char',
       rowterminator= '\n',
       Fieldterminator =',')


update data set COL1_OPERATOR = REPLACE(COL1_OPERATOR,'"',''),
                 COL1_SALES1 =REPLACE(COL1_SALES1,'"',''),
                  COL2_SALES2=REPLACE(COL2_SALES2,'"',''),
                   PROMO_ID= REPLACE(PROMO_ID,'"','')
                   
                   
select * from data