SSIS - Flat File Destination has trailing comma?

Question

I have a simple data flow task. It's a OLE DB Source to Flat File Destination setup.

One table, one column. Everything works great except there is a trailing comma (column delimiter) in the flat file when I'm done. Why is it putting an extra delimiter after the column as if there were another column?

Output

dog,
cat,
camel,
moose,

How do I get rid of that trailing delimiter?

Answer 1

Are you sure the row delimiter is not also a comma