Empty Data fields have default value 0000-00-00

More
8 years 2 weeks ago #13633 by m.hochstrasser
If I pull data from a system A and this hand over to the B system, empty data fields by default in the SQL database is set to 0000-00-00.
The value must have NULL in the data fields, if nothing is transmitted.
Is the configuration not ok or it's a bug.

Thanks for your help and answer

Please Log in or Create an account to join the conversation.

More
8 years 2 weeks ago #13634 by Peter.Jonson
Are you working with MS SQL server?
(Please read the forum rules)

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
8 years 2 weeks ago #13636 by m.hochstrasser
Application Name: Advanced ETL Processor Entreprise Version: 5.8.2.13
Windows Server 2008 R2 x64
It's a MySQL Database.

The Problem was detected after the update from AdvancedETLEnt5.8.0.16 to AdvancedETLEnt5.8.2.10

We have *.xls and *.csv imported and after the transformation wrote the value 0000-00-00 in the date field in the database. Before was the entry "NULL" in the data field.

Please Log in or Create an account to join the conversation.

More
8 years 2 weeks ago #13644 by Peter.Jonson
Can you try latest version please

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
8 years 2 weeks ago #13648 by m.hochstrasser
I have tested this with the version AdvancedETLPro5.8.2.19. The problem is not solved. See you at the Printscreen 0000-00-00.jpg.
Attachments:

Please Log in or Create an account to join the conversation.

More
8 years 2 weeks ago #13649 by admin
Can you try latest version please

5.8.2.20

- Addressed issues with loading empty date fields into MySQL
- Addressed issues with Split Transformation Function

Mike
ETL Architect

Please Log in or Create an account to join the conversation.