Home Forums SQL Server 2005 SQL Server 2005 Integration Services how to write expression for Derived Column transform RE: how to write expression for Derived Column transform

  • June 2, 2013 at 9:27 pm

    #1620368

    KoldCoffee (5/29/2013)

    I need to filter out all records as follows:

    where

    [Month 01] is null and

    [Month 02] is null and

    [Month 03] is null and

    [Month 04] is null and

    [Month 05] is null and

    [Month 06] is null and

    [Month 07] is null and

    [Month 08] is null and

    [Month 09] is null and

    [Month 10] is null and

    [Month 11] is null and

    [Month 12] is null

    The above is t-sql. I want to do in Derived Column. Tried the following but it's not parsing:

    [Month 01] !=NULL &&[Month 02] !=NULL] && etc.

    How to do the same in SSIS in Derived Column transform?

    Just a thought... if the data were normalized instead of pivoted, you wouldn't even have the NULLs to deal with.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)