how to convert DT_WSTR of length=1 to DT_STR of length=10??

• mhassanshahbaz

  SSC-Addicted

  Points: 416

  More actions

  November 23, 2010 at 4:31 am

  #149414

  source data type was unicode[DT_WSTR ] length was 255.

  so this query worked...

  [M/F] == (DT_STR,50,1252)"M" ? "MALE" : [M/F] == (DT_STR,50,1252)"F" ? "FEMALE" : "NA"

  but for

  source data type is unicode[DT_WSTR ] length is 1.what should be the querry???how to solve length issue???

• mhassanshahbaz

  SSC-Addicted

  Points: 416

  More actions

  November 23, 2010 at 4:41 am

  #1254327

  i triedin new Column in Derived Column

  Gender == "1" ? "MALE" : Gender == "0" ? "FEMALE" : "NA"

  but i gave NULL values

• Citiinvestor

  Old Hand

  Points: 340

  More actions

  November 23, 2010 at 7:12 am

  #1254438

  In Derived Column Transformation try using:

  (DT_STR,10,1252)[Columnname]