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