Hello Everyone,

I am using Activex Scripting in DTS to select a few columns from a table to a text file. Now I have to put a condition on one column i.e if the value is -ve then make it zero and for all other values, change the output value to the nearest upper 5. I can get the value for -ve = zero, but for the other part I am not able to get the desired result.I have tried using Round function.

Example Data:

Values------output
24 -----------25
73------------75
10------------10
20------------20
8-------------10
6-------------10
4-------------5

Any suggestions regarding this.

Thanks in advance

kalyan