Post reply

Data Conversion Task - convert to NOT NULL? Something like that?..

  • November 21, 2008 at 12:36 pm

    #215663

    In my Data Flow I'd like to check if the value is NULL

    then assign DQ_CD (data quality code) to "2" (value cannot be null).

    I know I can do it in the Script:

    If Row.TRANSITNUMok_IsNull = True Then

    Row.DQCD = 2

    End If

    but in this case you don't see how many rows failed this check in GUI

    because you don't have Error Output.

    I was wondering if maybe in Data Conversion Task I can do the same check

    and from Error Output assign DQ_CD to the corresponding RECORD_ID.

    In this case I can nicely see how many rows failed [NOT_NULL] check.

  • November 21, 2008 at 9:21 pm

    #901959

    Within your dataflow, use a conditional split and check the value in question for null using the ISNULL function. You can route those values that are NULL to a Derived Column transform where you can fill in the default value, and then use a Union All transform to bring the two sets of data back together before sending to your final output.

    hth,

    Tim

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

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

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