Forum Discussion

MJG2112's avatar
MJG2112
Icon for Advocate II rankAdvocate II
4 months ago
Solved

OLE 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. ...
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    4 months ago

    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

MJG2112's avatar
MJG2112
Icon for Advocate II rankAdvocate II
4 months ago

Shai_Karmani krishnakanth240 thank you for your advice.  The transform for the problematic data source uses Get Folder to pull together multiple input files.  I found one of these files had been saved with a footer record that should have been removed beforehand.  I've deleted it and all is now working.

krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
4 months ago

Happy to hear MJG2112. Please mark it as solution if the approach shared fullfilled your problem. Thank You!