Importing data error: SIGNEDDATA conversion error

The complete description is:

The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (8004202c): TransformCopy 'DTSTransformation__13' conversion error: General conversion failure on column pair 1 (source column 'SIGNEDDATA' (DBTYPE_STR), destination column 'SIGNEDDATA' (DBTYPE_NUMERIC)).)

We are trying to convert a value that come with miles separators, use the character "." (point) as separator and "," (comma) as decimal separator, we use a vb function (replace) to change the points for null string, but it doesn't work. Do you have any suggestion to solve this?

We are using BPC 7.0 MS SP3.

Thanks in advance,

Mariana Rodriguez.

Edited by: Mariana Rodriguez on Mar 23, 2011 4:15 PM