Post reply

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

  • 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???

  • 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

  • November 23, 2010 at 7:12 am

    #1254438

    In Derived Column Transformation try using:

    (DT_STR,10,1252)[Columnname]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply