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
    Commented Feb 19, 2019 at 5:19
  • Updated the original post with the output of the log file... Commented Feb 19, 2019 at 5:22
  • give like this data type Decimal field length 18 and 2 not like 18 and 0
    – Ravi.A
    Commented 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
    Commented Feb 19, 2019 at 6:26
  • Thanks, I changed it from 18,0 to 18,2 and it worked Commented Feb 19, 2019 at 7:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .