• Grasshopper,

    I know this is an old thread. but I am hoping you can help me out. SSIS is new to me and I am having a hard time with it. I have a CVS file with multiple columns, I only need data from 4 columns.

    Some columns look like this:

    Linux File System-ALL,ALL,ALL,ALL"

    the , causing issues for me during the import to SQL. as it reads the wrong column data.

    I tried your code but it didn't work for me.

    REPLACE(REPLACE(Column,",",""),"\"","")

    My column name is Client; what would the expression look like?

    Thank you