Forum Discussion
MJG2112
Advocate II
Advocate IIOLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number..
I've seen posts for this error but I'd still appreciate some advice on where to start with it. It's happening during the Load, which leads me to think it's not a problem during the Transform phase. ...
Hi MJG2112
Start by checking columns with Changed Type steps especially auto generated ones. Any calculated columns or measures expecting numbers. Source data for hidden issues like N/A, spaces, commas, nulls.Approach is to temporarily remove or disable type conversion steps. Reapply them one by one
krishnakanth240
Super User
Super UserHi MJG2112
Start by checking columns with Changed Type steps especially auto generated ones. Any calculated columns or measures expecting numbers. Source data for hidden issues like N/A, spaces, commas, nulls.Approach is to temporarily remove or disable type conversion steps. Reapply them one by one