none
Derived column in SSIS showing red color (error)

    Question

  • Hi,

    I want to convert a DT_WSTR (from an excel column 'Name') to DT_STR with 50 data length and to set it to NULL if the length of the Name is 0. So, after creating an excel source, I connected it to a derived column task with this expression:

    LEN(Name) == 0 ? NULL((DT_STR,50,1252)) : (DT_STR,50, 1252) Name

    I keep on seeing red font (error) after I specified this expression.

    Any suggestion what is missing?


    cherriesh


    • Edited by cherriesh Sunday, July 21, 2013 6:53 PM
    Sunday, July 21, 2013 6:52 PM

Answers

All replies