hi

thanks for your response.

please bear with me, i am new on this

i don't think so, I would be able to use that function in DTS packages.

Hi,

thanks for your response david, here is the cast function below i am trying but giving expected ')'.

Function Main()

CAST(DTSSource("ORDER_QTY") AS numeric(9)) * CAST(DTSSource("UNIT_PRICE") AS numeric(9)) * CAST(DTSSource("SELL_RATE") AS numeric(9)) =...

Hi,

But how, I really didn't get it . I have tried it so many time but giving me errors. can you tell me any other way please?

thanks