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.
精彩评论