I am extracting information from an excel sheet and loading it into a database. Before I load it into the database, I must transform all of the
"-" in the excel sheet to
I am currently trying to do this with the derived column transformation in a data flow object. It works if the data type is a Unicode string
[DT_WSTR], however it will not work with a double-precision float
The expression that works for the unicode strings is below.
[EquipmentID] == "-" ? (DT_WSTR,50)NULL(DT_WSTR,50) : [EquipmentID]
The expression that is not working for the double-precision floats is below.
[SideDoorType] == "-" ? (DT_R8)NULL(DT_R8) : [SideDoorType]