I am using DTS transform task to load file to a table. I have a column defined as numeric. In the file, this field is char. Whenever there is empty space, DTS won't convert char to numeric. I am writing my ActiveX script

Function Main()
If DTSSource("Col51") = " " then
DTSDestination("DISAB_PREMIUM_FIX" = "0.00"
Else
DTSDestination("DISAB_PREMIUM_FIX") = DTSSource("Col51")
End If

Main = DTSTransformStat_OK

End Function

I always get this invalid procedure call or argument error.

Does anyone has better idea to do this?