These are not the best ways likely, but a couple of ideas I have are:
1) Use SSIS and a script component with a dataflow to add text qualifiers to your output columns.
2) Query the table using For XML Path('') to create a xml output of the data.
If it's just one table and particularly if it contains a lot of rows (hundreds of thousand or more) I'd use bcp
; you don't need to worry about a delimiter then, but if you want to use SSIS then as Jeff said, pick a different delimiter. I usually use | (pipe) or ^ .