Use of Parameters instead of hardcoded values

  • In the derived column i am defining one of the values as

    v_type =

    ((v_provtype == "62" && (FINDSTRING(v_desc_string,"T5",1) > 0 || FINDSTRING(v_desc_string,"T6",1) > 0 || FINDSTRING(v_desc_string,"T7",1) > 0 || FINDSTRING(v_desc_string,"T8",1) > 0 || FINDSTRING(v_desc_string,"T9",1) > 0 || FINDSTRING(v_desc_string,"E8",1) > 0)) ? "60" : TRIM(v_provtype))

    But, the requirement is I cannot use the hardcoded values in the above which are (T5,T6,T7,T8,T9,E8). There are stored in a table as

    Select ParameterValue form dbo.common_Parameters.

    How do i rewrite the above to not use the hardcoded values and instead get the values from the table.

    Thanks.

  • A suggestion, use a Script Component in the Data Flow instead of the Derived Column.

    😎

  • How.... can u let me know

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

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