l've 2 variables A & B from source database which i used to calculate C with the following formula, i.e.
C = 100 * A/B
In case of B = 0 (DIV BY ZERO), C should be equal to -9999.
l've set the datatype for A & B are INT, C is FLOAT at targetting database.
So l used to derived column to calculate C as,
B == 0 ? -9999 : 100 * A/B
After l run the package, l realize that all my C is INTEGER rather than FLOAT.....it seems that SQL server has evaluate the wrong datatype for me....anyway to overcome this?
This should not be a problem - you can map an integer in the data flow to a float at the destination without any issues.
Donald Farmer
|||Fact is, l get a Integer at the end :(, even the data and meta data is float........|||
Try casting A and B as floats before using them in your calculation.
-Jamie
No comments:
Post a Comment