Error in Text Output with a delimiter but no quotes

[sdesabhatla]

Hi, 

I am trying to generate a txt file that has dynamic SQL Insert statements,The string I am generating in the file is as below

INSERT INTO ABC (A,B,C,D,E,F,G) VALUES ( 'ONBD','C1-BL ','C1 ','CIP','CBL ',' ','1 ' );

With the below setting for Output I get the line enclosed in Double quotes

When I set the 'Quote Output Fields' to 'Never' and had a delimiter  semicolon (; )it will error out 

Error:When Quote Mode is Never, field cannot contain a delimiter character

How do I generate the txt file with no Quotes and end  the line with a semicolon?

Thanks

[DavidP]

What it's telling you is that in csv mode, you can't leave the quotes out and then have the delimiter that you've chosen, a semicolon, in your data. Since you've already added the semicolon into the data, just choose a space (\s) or newline (\n) as your delimiter or nothing (\0).

You could also choose flat ascii as the output type if you want.