I have a package wherein I move data from Excel to SQL.
I need to add a step in between where i can remove leading and trailing quotation marks from a field.
example "ABC" should be ABC.
Should I use a derived column between source and destination table?
I tried using the expression Replace([column name],""","") but it gives an error.