Remove commas from text file ssis 2010

[Joanna Webster]

Hi SSIS 2010 How do you please stop the commas or delete the commas..when sending data from a dB source SQL to a flat file txt file please Just using col1 col2 col3 as column names Table name is Recipe Chicken,mushroom,cheese I wish to have Chicken mushroom cheese Basically a space instead of comma Please help?

[Lost User]

Where does this text come from, and how are you accessing it?

[phil o]

Flat File Connection Manager[^] You have to select a different separator in the Columns page. Tabulation may be adequate, or some other character of which you are sure it cannot appear in stored strings.

noop()