• John, I think I know what u trying to say using derived column. but is there somewhere where i can find code to do the increment.

    Probabaly what i am thinking is dcelare a variable say varInteger of type int, intial value to 0

    then bring Derived transformation to hold value in this variable. but how do i incremnet its value using script transformation.?