Search code examples
csvssisdelimiterderived-column

SSIS Derived Column Transformation Editor

I have a csv file that I'm loading into a database example of content of csv

"name","house,up a hill","drive"

I have set the column delimiter to be ", within the connection manager

which gives me data in 3 columns

column 1 =   "name 
column 2 = house,up a hill
column 3 = drive"

I need to then remove any " from any of the text in the three columns I have added Derived Column to my package and and added the following 

REPLACE(column 1,'"','')

this hasn't worked, I thought the replace worked as column name, text to replace, replace with

any help would be appriciated

Solution

  • Write it like this in your derived column task

    REPLACE( [COLUMNAME],"\"","")