Anyone run into an InvalidDecimalScale error in the SFMC CSV data import?

I came up with a contrived example to test. I made my data extension super simple: Simple Data Extension

It's a data extension with three fields. A number, a decimal and text field. I'm uploading a very simple file:


The third row uploads correctly. The first two do not. It looks like it's due to the values after the decimal point e.g. "7.0" or the "0.00"

The field is a decimal field? Why is there an error? Is there a way to fix this?

EDIT: Error I'm getting in the text file are:

Row Number  Error Number    Error Code  Error Details   Row Data
0   88340068    InvalidDecimalScale InvalidDecimalScale [89228][7.0][Bad]
1   88340069    InvalidDecimalScale InvalidDecimalScale [89229][0.00][Bad]
  • what error you getting ?
    – Ravi.A
    Feb 19, 2019 at 5:19
  • Updated the original post with the output of the log file... Feb 19, 2019 at 5:22
  • give like this data type Decimal field length 18 and 2 not like 18 and 0
    – Ravi.A
    Feb 19, 2019 at 6:19

1 Answer 1


try like this see this image you get some ideaenter image description here

  • give length 18,2 not like 18,0 then import records
    – Ravi.A
    Feb 19, 2019 at 6:26
  • Thanks, I changed it from 18,0 to 18,2 and it worked Feb 19, 2019 at 7:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.