Casting in transformation

[Jenns]

I'm importing a text file into a table using a DTS package. The transformation is being done with VBscript. I need to change the script to convert (or cast) some fields as float. The text file brings them in as text and the database fields are float, thus the package fails. I have tried this code:

DTSDestination("SBR-ORIG-AMT") = cast(DTSSource("Col029") as float)

The error I get says it's expecting a ")".

CONVERT doesn't work either.

Can anyone tell me what I'm doing wrong?

Thanks!
Jenn

 

[mercwrought]

sorry it took me a mint to find the comand

DTSDestination("SBR-ORIG-AMT") = CDbl(DTSSource("Col029")

this is an active x script not sql code so you have to use that lanuge