Lrn
Reputation: 327
Handling escape characters when using csv file format as source in SSIS
How to escape double quotes when using csv file as the input in SSIS when the csv file has default comma seprated values.
Upvotes: 0
Views: 2390
Answers (1)
user756519
Reputation:
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.
Upvotes: 1
Related Questions
- Is there a way to escape a double quote within a text qualified string on a SSIS Csv import?
- How to remove double quotes surrounding the text while importing a CSV file?
- SSIS Import CSV delimited with quotes
- Importing csv file into SQL Server using SSIS with multiple double quotes in data
- SSIS: how to handle a quote-qualified csv file with quotes inside quotes
- SSIS: Export and import CSV file with special characters
- SSIS exporting data to flat file renders double quotes as hexadecimal characters
- SSIS - How can I set the escape character?
- Using Excel to create a CSV file with special characters and then Importing it into a db using SSIS
- Import .csv file through SSIS Package without double Quotes