开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜