CODEWITHSUNDEEP
ssisssis-2012data-conversionflatfiledestination
Asin
Asin

Reputation: 73

comma in csv data in ssis package

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 ?

Upvotes: 1

Views: 2301

Answers (1)

john McTighe
john McTighe

Reputation: 1181

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

Upvotes: 1

Related Questions