I am importing the values for field Atype from a .csv file as DT_STR, 13 and I need to fit them into a bit type CType field. When I write the conditional split ((ISNULL(Atype)?"a":Atype)!=(ISNULL(CType)?"9":CType)) it says that the DT_WSTR and DT_I4 types are incompatible and that I need to explicitly cast with a cast operator. I haven't been able to make it work, can someone please show me how to explicitly cast?
TIA