Post reply

How to count the number of coloumns on a condition in ssis package

  • November 5, 2008 at 2:20 pm

    #154889

    Here are my source table fields

    col1

    col2

    col3

    col4

    col5

    col6

    col7

    col8

    col9

    col10

    col11

    and the correspondinf fields are

    somenumber

    10/10/1984

    12/12/2008

    16

    16

    10

    11

    12

    13

    0

    0

    Based On col2 date, I need to count the number of months that has a value>0 for col1, and continues until it reaches a 0 value.

    I need to build a ssis package on this conditon. My target table should have the count of the coloumns which are non zeros depending upon the date in coloum2

    Please help me out..its very urgent

  • November 5, 2008 at 8:02 pm

    #894633

    Sorry... not enough info. Please refer to the link in my signature for quicker/better answers.

    --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)

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

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