none
SSIS DERIVED COLUMN

    Pertanyaan

  • I am using the following expression in dervide column to validate empty and non empty rows

    (DT_STR,1,1252)(POLORG_Date == "" || REPLACENULL(POLORG_Date,"") == "" ? "I" : (DT_STR,1,1252)((DT_UI4)SUBSTRING(POLORG_Date,1,4) >= 1 && (DT_UI4)SUBSTRING(POLORG_Date,1,4) <= 9999 ? "V" : "I"))

    Getting failed the above condition

    Kamis, 14 Juni 2018 19.47

Semua Balasan

  • can you post how values for POLORG_Date will be like?

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Kamis, 14 Juni 2018 20.47
  • Try this:

    =IIF(Len((DT_STR,1,1252)(POLORG_Date)) > 0, true, false) 


    A Fan of SSIS, SSRS and SSAS

    Kamis, 14 Juni 2018 21.33
  • (DT_STR,1,1252) REPLACENULL(POLORG_Date,"") == "" ? "I" : (DT_STR,1,1252)((DT_UI4)SUBSTRING(POLORG_Date,1,4) >= 1 && (DT_UI4)SUBSTRING(POLORG_Date,1,4) <= 9999 ? "V" : "I"))

    Try this and make sure the POLORG_Date values when it is not NULL or "" then it should be valid produce result for

    SUBSTRING(POLORG_Date,1,4) 


    mohammad waheed

    Kamis, 14 Juni 2018 21.34