1

i am passing data from database to csv file i.e oledbsource to flat file destination. in few of the columns data, it contains comma value. currently the comma is separating the data into different columns. Instead of replacing the comma with other value, can we retain it in column data without the data being separated in different columns ?

Asin
  • 63
  • 1
  • 9
  • Why replace anything? Just set the correct separator and text qualifier in the destination's settings. Not my downvote, but ... what did you try? – Panagiotis Kanavos Nov 29 '16 at 17:52
  • I am passing the data from oledb datasource to flatfile destination. Currently the delimeter is comma and the text qualifier is none – Asin Nov 29 '16 at 18:02

1 Answers1

1

If you use Text Qualifier = " then this will wrap each text field in double quotes

So if the field has a comma it will still work.

Eg Field = Jones, Fred will be saved as "prev field","Jones, Fred", "next field", 1, 2 etc

john McTighe
  • 1,181
  • 6
  • 8