Okay, I will add new columns and alter the mappings in my OLE DB destination. thank you

all of you provided very helpful feedback which aligned with most of what i was trying. i finally figured out my problem. since i cant change the data type for...

i am not sure how this will show up after changing the file extension. i wasnt able to upload as .csv

also, i am not going to be opening up the...

Not enough... I have tried the following in conditional split transformation editor and failed

REPLACE([QuantityUnits],"(","-")

REPLACE(QuantityUnits,')','')

I have tried the following in Derived Column Transformation editor and failed

REPLACE(REPLACE([QuantityUnits],”(“,”-”),”)“,””)

SUBSTRING([QuantityUnits],1,1) == "(" ? REPLACE(REPLACE([QuantityUnits],"(","-"),")","") :...

how do i add that as an expression in the Derived Column Transformation Editor? my data is coming from a csv into a staging table which has numeric and decimal...