Date Format Error - Invalid Argument to date encode

This error is in Advanced ETL Processor Enterprise

I had to change the date format from a previous import, and not I am getting a error that says Invalid argument to date encode.

The format I had to change to was DD-MMM-YYYY

All setup and test screenshots are attached.

It is hard to tell what is wrong with it without seeing the data.

Can you post table creation script, mapping and source file please.

Peter

How do I generate the creation script and mapping?

1. For mapping

Press forth button from the right (save icon)


2. To generate script

Open SQL server Management studio

Highlight the table

Right click on and select generate script create to ETC

Mike

Here is more detailed guide

www.etl-tools.com/articles/generating-ta...creation-script.html


Mike

Hi Mike,

I have isolated what the problem is, but not sure how to deal with it.

If you look at the properties of the attached file, you will see that it has a Dec 31, 1969. This is the way that we receive the export file, and we cannot change it.

When the transformer tries to read this file, it gives the error that I mentioned. The only way to get the transformer to read the file is to open and then save it (it then udpates the file properties date to current date).

I did try the file with an old version of ETL Processor, and it was able to read it so this seems to be an issue that has been introduced in your newer versions.

To replicate the error try to read the file as it is without opening and saving it.