I have a field called something like TYPE & the values are variant in it. I want the SSIS to export the result to CSV & while exporting, if it finds the , in column TYPE only that line/value should be double quoted. Eg:
TYPE Begin Bag 1,000 mL Miscellaneous 20ml Final 2,000 mL Begin Bag 1 mL
the result should be (in the csv format exported): TYPE "Begin Bag 1,000 mL", Miscellaneous 20ml, "Final 2,000 mL", Begin Bag 1 mL
I tried using the Derived column "\""+ TYPE +"\"" but that just adds Double quotes to every value for column TYPE.