Search code examples
ssisssis-2012ssis-2008

Bucket analysis in SSIS Derived column

I have a do a bucket analysis of some days calculation in SSIS staging

please help me in fixing this 

DAYS <=90 = 0-3 Months
DAYS >=91 &&  DAYS <=180 = 3-6 Months
else > 6 Months

which I tried to frame like below but not working, and i am very new to this, please suggest

(DAYS <="90") ? "0-3 Months": ((DAYS >= "91") &&  (DAYS <= "180") ? "3-6 Months": "> 6 Months")
Solution

  • Your comparisons should be against numbers, not strings (they shouldn't have the enclosing "). Other than that, the expression seems OK.

    Make sure that DAYS is of an integer type and not STR (or WSTR) because comparing numbers behave different than comparing strings. You can try casting DAYS to I8 before the comparison if its a string type.