none
SSIS Divide by zero error RRS feed

  • Question

  • Hello

    I have a SSIS package that errors of my Derived Column with a divide by zero error.

    I have a Derived Column before the one that errors that sets any Null fields to 0, this works fine.

    But the Derived Column that has the expression below errors 

    Sales_QTY == 0 ? 0 : Shops_Stock_QTY == 0 ? 0 : Sales_QTY / (Shops_Stock_QTY - Sales_QTY)

    How do I correct the expression so it works?

    Regards

    SQLSearcher99

    Thursday, December 14, 2017 11:37 AM

Answers

All replies