Handling escape characters when using csv file format as source in SSIS

How to escape do开发者_开发百科uble quotes when using csv file as the input in SSIS when the csv file has default comma seprated values.

---

If you want to replace the double quotes within the CSV file's column data, please refer my answer in this Stack Overflow question. The example in the question explains how to replace/remove double quotes using Derived Column Transformation task.

Hope that helps.