CODEWITHSUNDEEP
visual-studio-2010ssis
Joeysonic
Joeysonic

Reputation: 265

Remove commas or change commas to spaces SSIS 2010

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?

Upvotes: 2

Views: 1336

Answers (1)

Joeysonic
Joeysonic

Reputation: 265

Just go to advance properties...and manually change each column delimiter ..as blank or just hit space bar..and it works

Thanks team for advice..x

Upvotes: 1

Related Questions