DTW reimport of existing data to UPDATE always fails

[neilos]

Hi Experts,

I have imported successfully some new data, specifically Special Prices.
Using SpecialPrices.csv, SpecialPricesDataAreas.csv and SpecialPricesQuantityAreas.csv .

The initial import went well, but I made a mistake on a few of the prices to be imported, and now I have corrected the prices and tried to UPDATE existing data, using the modified files, it only successfully imports the first record and all others fails with 'Invalid Date Range Application-defined or object-defined error.65171'

I have tried this as tab delimited txt files too, and I get the same result.

Any ideas as to what could be causing this?

The date range I have is this format (yyyymmdd):

DateFrom
20201020

DateTo
20301231

And it is the same on every line, but only the first line successfully imports.
See attached Log screenshot

[msundararaja_perumal]

Please share the template, thanks.

[neilos]

special1.txt
special-prices-data-areas1.txt
special-prices-quantity-areas1.txt
I have removed a number of lines, so the files are not 200+ lines long, to make it easier.
The issue persists with this.