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),
bulk insert data from 'C:\SSISLoad\Data.txt'
with( DATAFILETYPE = 'char',
update data set COL1_OPERATOR = REPLACE(COL1_OPERATOR,'"',''),
select * from data
Vijay is here to learn something from you guys.