There are different ways to modify strings in a SQL Server Integration Services (SSIS) process. You could modify the strings as they are read from SQL Server by using SQL code in a query or view. Or you could modify the string once it is in your data flow in SSIS by using string functions in a derived column.
The REPLACE function is ideal for such a scenario, but there is a catch. The REPLACE function uses double quotes. So if you want to replace double quotes, how can it be done?
What you do here is use \” in place of your double quote, so your REPLACE function call looks like this:
REPLACE (My_String, “\””, “”)
This REPLACE function will remove double quotes from your string.