Unanswered: DTS load empty spaces to a numeric type
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
If DTSSource("Col51") = " " then
DTSDestination("DISAB_PREMIUM_FIX" = "0.00"
DTSDestination("DISAB_PREMIUM_FIX") = DTSSource("Col51")
Main = DTSTransformStat_OK
I always get this invalid procedure call or argument error.