hi
in ssis i have been asked to divide one column by another. it keeps erroring out as something both columns have 0 in them is there anyway around this.
Divide by zero is the problem. Numerator being zero would not cause any errors. To avoid division by zero, you should use a derived column transformation such as
Denominator == 0 ? NULL(DT_I8) : Denominator
If you indeed want to calculate the 0/0, that would involve a little bit of math ( L'Hospial's rule and such), which is beyond the scope of this forum.
is there a way of coding somethig like this in ssis
IF (Cost = 0, 0, MV / Cost)
Are you sure you want 0 in that scenario? I use NULL (as per the code that James proposed)
Otherwise use the syntax James proposed and just change it to use your objects [Cost] and [MV]