SSIS Derived Column Condions

108 Views Asked by At

Here I am checking the control flag if the flag is Yes then I need to pass 1 and if the flag Is no then I need to pass 0 from the derived column, this is my column. it is passing only 0 even though the flag is Yes

DerivedColumnName  Derived Column       Expression                      DataType
CopySerial_Control <Add as newcolumn>   Serial_Control == "Yes"? 1: 0   Four-Byte  
0

There are 0 best solutions below