Post reply

How to change value of a field

  • March 6, 2008 at 12:47 pm

    #154179

    A newbie question:

    How do I change the value of a field in a flow?

    I have a Lookup data flow task that goes out to a SQL Server table; if the value is not found, it just ignores the error and the field in the flow is a Null. I want to change this Null value in the field to a 0. How do I do this?

    Thanks for your help.

  • March 6, 2008 at 12:58 pm

    #786317

    Add a Derived Column Transformation after the Lookup and use the expression "ISNULL([fieldname]) ? 0 : [fieldname]"

    Peter

  • March 6, 2008 at 12:58 pm

    #786318

    The Derived Column data flow transformation seems to do the trick for me.

    I use something like: ISNULL(BenefitId) ? 0 : BenefitId to replace the null in the BenefitId field in the flow.

  • March 6, 2008 at 12:59 pm

    #786320

    Many thanks Peter; that does the trick.

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

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